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

>
> Let's do whatever the standard says.

1) three level namespace (catalog, schema, name)
2) schemas are mandatory (there cannot be objects that don't belong to some
schema)
3) schemas are explicitly created
4) SET CATALOG and SET SCHEMA statements
5) CATALOG_NAME and SCHEMA_NAME columns in every system table

Not very close to what you've been proposing so far, huh?


Dmitry