ALLBASE/SQL Reference Manual (36216-90216)

Appendix A 603
SQL Syntax Summary
CREATE TABLE
CREATE [PRIVATE
PUBLICREAD
PUBLIC
PUBLICROW ]TABLE [ Owner. ] TableName
[LANG = TableLanguageName ]
({ ColumnDefinition
UniqueConstraint
ReferentialConstraint
CheckConstraint }[,...])
[UNIQUE HASH ON ( HashColumnName [,...]) PAGES = PrimaryPages
HASH ON CONSTRAINT [ ConstraintID ] PAGES = PrimaryPages
CLUSTERING ON CONSTRAINT [ ConstraintID ]]
[IN PARTITION { PartitionName
DEFAULT
NONE }]
[IN DBEFileSetName1 ]
Column Definition
ColumnName { ColumnDataType
LongColumnType [IN DBEFileSetName2 ]}
[LANG = ColumnLanguageName ]
[[NOT] CASE SENSITIVE]
[DEFAULT{ Constant
USER
NULL
CurrentFunction }]
[NOT NULL [{UNIQUE
PRIMARY KEY} [CONSTRAINT ConstraintID ]]
REFERENCES RefTableName [( RefColumnName )][CONSTRAINT ConstraintID ]
[...]
CHECK (SearchCondition) [CONSTRAINT ConstraintID]
[IN DBEFileSetName3 ] ][...]
Unique Constraint (Table Level)
{UNIQUE
PRIMARY KEY}( ColumnName [,...]) [CONSTRAINT ConstraintI D]
Referential Constraint (Table Level)
FOREIGN KEY ( FKColumnName [,...])
REFERENCES RefTableName [( RefColumnName [,...])] [CONSTRAINT ConstraintID ]
Check Constraint (Table Level)
CHECK ( SearchCondition ) [CONSTRAINT ConstraintID ] [IN DBEFileSetName3 ]
CREATE TEMPSPACE
CREATE TEMPSPACE TempSpaceName
WITH [MAXFILEPAGES = MaxTempFileSize ,]LOCATION =’ PhysicalLocation ’