Subject Re: [Firebird-Architect] Multi-level name space
Author Martijn Tonies
> >IMO, "hungry.wolf" is an identifier for an object named hungry.wolf in an
> >unspecified schema. Why? Because the identifier starts at the first quote
> >and
> >ends at the second.
> >
> >It would also go against any other database system that I know of
(ignoring
> >Netfrastructure cause it's not a database system ;) ... )
> >
> >
> >
> fyi:
>
> "create table Tables (\
> tableName varchar (128) not null,\
> schema varchar (128) not null,\


Here I see two columns for a two-level namespace.

What would be your reason for Firebird not having two columns, but
a VARCHAR(256) column?

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