SQL$HELP_OLD72.HLB  —  CREATE  TABLE  Format
   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 -----+
Close Help