"Arno Brinkman" <firebird@...> wrote:

>
> I would stay by two-level, because the thirth-level should be the database
> (alias) reference and the fourth the database-engine.
>
> SELECT * FROM <db-engine>.<database>.<schema>.<object>

If you're talking about cross-db statements, I'd rather prefer the oracle
approach:

SELECT * FROM <schema>.<object>@<database>

where <database> is an explicitly declared alias of the external data
source. This clearly separates the two features in regard to the names
management.


Dmitry