Subject | Firebird qualified table names |
---|---|
Author | Farid |
Post date | 2006-03-03T22:12:01Z |
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
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