Subject Firebird qualified table names
Author Farid
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.

Farid