Martijn Tonies wrote:

>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,\
type varchar (16),\
dataSection int,\
blobSection int,\
tableId int,\
currentVersion int,\
remarks text,\
viewDefinition clob,\
primary key (tableName, schema));";

"upgrade table Fields ("
"field varchar (128) not null,"
"tableName varchar (128) not null,"
"schema varchar (128) not null,"
"domainName varchar (128),"
"repositoryName varchar (128),"
"collationsequence varchar (128),"
"fieldId int,"
"dataType int,"
"length int,"
"scale int,"
"flags int,"
"remarks text,"
"primary key (schema, tableName, field));";

--

Jim Starkey
Netfrastructure, Inc.
978 526-1376