> I am new to Firebird and I was wondering if Firebird supports
> qualifying a table name with table owner/schema. 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? 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.

It isn't.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com