The following is the syntax for the column_constraint_clause in the CREATE TABLE statement. See the description of the keywords in the table_constraint_clause section.
{ [NULL | NOT NULL] | [UNIQUE | PRIMARY KEY] | [FOREIGN KEY (column
[,column
...])] [REFERENCES [schema
.]table_name
[(column
)] [ON DELETE CASCADE] ] [CHECK (condition
)] } [USING INDEX [PCTFREEinteger
] [PCTUSEDinteger
] [INITRANSinteger
] [MAXTRANSinteger
] [TABLESPACEtablespace_name
] [STORAGE ( [INITIALinteger
[K | M]] [NEXTinteger
[K | M]] [MINEXTENTSinteger
[K | M]] [MAXEXTENTS {integer
| UNLIMITED}] [PCTINCREASEinteger
] [FREELISTSinteger
] [FREELIST GROUPSinteger
] ) [NOSORT] [LOGGING | NOLOGGING] ] [EXCEPTIONS INTO [schema
.]table_name
] [{ENABLE [VALIDATE | NOVALIDATE] | DISABLE} ] [[NOT] DEFERRABLE [INITIALLY {IMMEDIATE | DEFERRED}] ] [[INITIALLY {IMMEDIATE | DEFERRED}] [[NOT] DEFERRABLE] ]