> > 3. A qualified table name is represented in the system tables as
> > <schema>.<tablename> as in "myschema.mytable"
>
> What about:
> create table "myschema.mytable" ()
> and
> create table "myschema"."mytable" ()

This should be it. The others don't make sense with regard to
delimited identifiers. Cause what Jim is saying, is that any dot
resolves to a schema name.

This is rather strange, cause a dot is valid in delimited identifiers.

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