CREATE -+---------------------------+-> TABLE --------+
+-> INFORMATION ------------+ |
+-> GLOBAL -+-> TEMPORARY --+ |
+-> LOCAL --+ |
+---------------------- <------------------------------+
++-> FROM <path-name> -+-------------------+-----------------------+
| +-> ALIAS <alias> --+ |
+-> <table-name> -+-------------------------------+-> table-body -+
+-> STORED NAME IS stored-name -+ |
+---------------------<------------------------------------------+
+-+--------------------------------+->
+-+--> create-table-attributes -++
+---------------<-------------+
create-table-attributes =
---+-> COMMENT IS --+-> 'quoted-string' -+------+->
| +-------- / ---------+ |
+-> COMPRESSION IS -+-> ENABLED ---+---------+
| +-> DISABLED --+ |
+-> DISABLE --+-> cre-enable-disable --------+
+-> ENABLE ---+ |
+-> LOGGING ---------------------------------+
+-> NOLOGGING -------------------------------+
+-> ON COMMIT -+-> DELETE ----+-> ROWS ------+
+-> PRESERVE --+
table-body =
-+-> (column-constraint-list) ---------------------------------+->
| |
+-> LIKE <other-table-name> --+------------------------------++
+--> (column-constraint-list) -+
cre-enable-disable =
-+-> ALL CONSTRAINTS ---------------------+->
+-> CONSTRAINT <constraint-name> --------+
+-> PRIMARY KEY -------------------------+
+-> UNIQUE ( -+- <column-name> +-> ) ----+
+------- , <-----+
col-definition =
--> <column-name> --+
+---------------+
+---> column-type ---+--------------------------+-+--+
| +->DEFAULT value-expr | | |
| +->column-identity --------+ | |
+---> COMPUTED BY value-expr ---------------------+ |
+-------------------------<--------------------------+
+-+--------------------+----------------+
+-> col-constraint --+ |
+--------------------------<------------+
++------------------------+-----+-----------------------+->
+-> comment-is-clause --+ +-> sql-and-dtr-clause -+
column-constraint-list =
--+--+-> col-definition -------+-----+->
| +-> table-constraint -----+ |
+---------------- , <--------------+
column-identity =
--> IDENTITY --+--------------------------------------------------+-->
+- ( <start-with> --+----------------------+-> ) --+
+-> , <increment-by> --+
column-type=
--+-> data-type -----------------------------------+-->
+-> <domain-name> -------------------------------+
+-> references-clause ---------------------------+
+-> AUTOMATIC --+-----------+--> AS value-expr --+
+-> INSERT -+
+-> UPDATE -+
data-type =
-+-> char-data-types -----------------------------------------+-->
+-> TINYINT --------------+-----+------------+---------------+
+-> SMALLINT -------------+ +-> ( <n> ) -+ |
+-> INTEGER --------------+ |
+-> BIGINT ---------------+ |
+-> FLOAT ----------------+ |
+-> NUMBER -+----------------------------------+-------------+
| +-> ( -+-> <p> -+-+----------+-> ) + |
| +-> * ---+ +-> , <d> -+ |
+-> LIST OF BYTE VARYING --+------------+--+--------------+--+
| +-> ( <n> ) -+ +-> AS BINARY -+ |
| +-> AS TEXT ---+ |
+-> DECIMAL -++------------------------------+---------------+
+-> NUMERIC -++-> ( --> <n> +----------+-> ) + |
| +-> , <n> -+ |
+-> REAL ----------------------------------------------------+
+-> DOUBLE PRECISION ----------------------------------------+
+-> date-time-data-types ------------------------------------+
char-data-types =
-+-> CHAR -------------++------------++--------------------------------+-+->
+-> CHARACTER --------++-> ( <n> ) -++-> CHARACTER SET char-set-name -+ |
+-> CHAR VARYING -----+ |
+-> CHARACTER VARYING + |
+-> VARCHAR --+> ( <n> ) ---+--------------------------------+----------+
+-> VARCHAR2 -+ +-> CHARACTER SET char-set-name -+ |
+-> LONG VARCHAR ------------------------------------------------------+
+-> NCHAR --------------+-+------------+--------------------------------+
+-> NATIONAL CHAR ------+ +-> ( <n> ) -+ |
+-> NATIONAL CHARACTER -+ |
+-> NCHAR VARYING --------------+-+------------+------------------------+
+-> NATIONAL CHAR VARYING ------+ +-> ( <n> ) -+ |
+-> NATIONAL CHARACTER VARYING -+ |
+-> RAW -> ( <n> ) -----------------------------------------------------+
+-> LONG -+--------+----------------------------------------------------+
+-> RAW -+
date-time-data-types =
--+-> DATE -+----------+-----------------+-->
| +-> ANSI -+ |
| +-> VMS ---+ |
+-> TIME ---> frac --------------------+
+-> TIMESTAMP --> frac ----------------+
+-> INTERVAL ---> interval-qualifier --+
col-constraint=
---+---------------------------------++
+-> CONSTRAINT <constraint-name> -+|
+------------------------------------+
+-> PRIMARY KEY -----------------+
+-> UNIQUE ----------------------+
+-> NOT NULL --------------------+
+-> NULL ------------------------+
+-> CHECK (predicate) -----------+
+-> references-clause -----------+
+------------>-------------------+
+-------------<------------------+
+----+----------------------------+-->
+--> constraint-attributes --+
references-clause =
REFERENCES <referenced-table-name> -+
+-----------------<----------------+
+-+--------------------->-------------------+->
+-> ( -+> <referenced-column-name> +-> ) -+
+----------- , <------------+
sql-and-dtr-clause =
-+-> QUERY HEADER IS -+> <quoted-string> +-------------------+->
| +------ / <--------+ |
+-> EDIT STRING IS <quoted-string> -------------------------+
| |
+-> QUERY NAME FOR -+-> DTR --------+-> IS <quoted-string> -+
| +-> DATATRIEVE -+ |
+-> DEFAULT VALUE FOR -+-> DTR --------+-> IS literal ----+
+-> DATATRIEVE -+
literal =
--+-> numeric-literal ----+--->
+-> string-literal -----+
+-> date-time-literal --+
+-> interval-literal ---+
+-> dbkey-literal ------+
table-constraint =
---+---------------->------------------+----+
+-> CONSTRAINT <constraint-name> ---+ |
+------------------------------------------+
+--> table-constraint-clause --------------+
+------------------------------------------+
+---+---------------------------+------------->
+-> constraint-attributes --+
table-constraint-clause =
-+----------------------------------------------+-->
+-> PRIMARY KEY -> ( -+-> <column-name> -+> ) -+
| +------- , <-------+ |
+-> UNIQUE -> ( -+> <column-name> +-> ) -------+
| +------- , <-----+ |
+-> CHECK (predicate) -------------------------+
+-> FOREIGN KEY -> ( -+> <column-name> +-> ) + |
+------- , <-----+ | |
+-----------------------<------------------+ |
+-> references-clause ------------->---------+
constraint-attributes =
-+-> DEFERRABLE -------------+------------------------------+-+->
| +-> INITIALLY +-> IMMEDIATE --++ |
| +-> DEFERRED ---+ |
+-> NOT DEFERRABLE ---------+-------------------------+------+
| +-> INITIALLY IMMEDIATE --+ |
+-> INITIALLY IMMEDIATE ----+-------------------+------------+
| +-> DEFERRABLE -----+ |
| +-> NOT DEFERRABLE -+ |
+-> INITIALLY DEFERRED -----+-------------------+------------+
+-> DEFERRABLE -----+