"Jim Starkey" <jas@...> wrote:

>
> 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.


Dmitry