> > If the default schema were set to "myschema", then "table1" would
> > resolve to "myschema.table1". If that didn't exist, it would resolve to
> > an unqualified "table1". There is question of what happens if the
> > default schema is "myschema", the table "myschema.table1" exists, and
> > you want to reference the unqualified "table1". I can think of about a
> > dozens possible solutions, none the least bit interesting.
>
> We need to support some predefined schema name which means "no schema". So
> you may specify "NONE"."MY_TABLE" if you need to reference a non-schema'd
> object from the context having a default schema set up. An attempt to

create

> "NONE"."MY_TABLE" should either throw an error or silently create an

object

> without a schema.

"dbo", anyone? ;)

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