At 09:12 AM 4/03/2006, you wrote:

>I am new to Firebird and I was wondering if Firebird supports
>qualifying a table name with table owner/schema.

No. Firebird doesn't support schemas or owner namespaces.

>I have tried this but
>it did not work. For example, if SYSDBA is the owner of table TEST,
>then I would use a query such as:
>select
>..
>from
>SYSDBA.TEST
>
>Does anybody know if this is supported by Firebird?

No. Ownership of objects is irrelevant except with regard to access
permissions; and SYSDBA has owner privileges on everything, anyway,
i.e. it is not an ordinary user in the sense you are talking about.

>My application is
>a cross-dbms app and it supports Firebird but I want to make sure that
>if I don't qualify a table name by its owner, then Firebird would not
>allow having another table by the same name but with different owner,
>for example, USER25.TEST, etc.

Can't quite make sense of all the double negatives :-) but every
identifier in Firebird must be unique, except column identifiers,
which are restricted to uniqueness within a table or view; and PSQL
variables (local, as well as input and output argument identifiers)
which are unique in the immediate scope of the PSQL module.

./heLen