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 -----+