> > Well, first question - how does it look from SQL standard POV?
>
> AFAIK SQL stand. does not define external datasources nor external
> tables.
>
> AFAIK SQL:2003 defines only :
> <catalog>.<schema>.<table>
>
> > With slightly modified (avoid '@' in favour of '.')
> I suggest also '.' instead of '@' like MS SQL for linked servers:
> <server>.<catalog>.<schema>.<table>
> (<datasource>..<table>)

.. <- the worst syntax I've ever seen.


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, 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