SQL$HELP_OLD72.HLB  —  CREATE  DOMAIN  Format
  CREATE DOMAIN -+
  +--------------+
  +-> <domain-name> +-----------------------------------++
  |                 +-> STORED NAME IS <stored-name> ---+|
  |+-----------------------------------------------------+
  |++-> IS data-type -+-+----------------------------+---+
  | +-> AS data-type -+ +--> DEFAULT value-expr -----+   |
  |   +--------------------------------------------------+
  |   +-+--------------------------------------------+-+
  |     +-> COLLATING SEQUENCE IS <collation-name> --+ |
  |     +-> NO COLLATING SEQUENCE -------------------+ |
  |   +------------------------------------------------+
  |   +-+----------------------+-+------------------------++->
  |     +-> domain-constraint -+ ++> sql-and-dtr-clause -++|
  |                               +---------<------------+ |
  +-> FROM -> <path-name> +----------------->----------+---+
                          +-> DATABASE ALIAS <alias> --+

  domain-name =

  -+---------------------------+-> <name-of-domain> --->
   +-+-> <schema-name> -+-> . -+
     +-> <alias> -------+

  data-type =

  --+-> char-data-types ---------------------------+-->
    +-> TINYINT --------------+-----+----------+---+
    +-> SMALLINT -------------+     +-> (<n>) -+   |
    +-> INTEGER --------------+                    |
    +-> BIGINT ---------------+                    |
    +-> LIST OF BYTE VARYING -+                    |
    +-> DECIMAL -++-----------------------------+--+
    +-> NUMERIC -++-> ( -> <n> +----------+-> ) +  |
    |                          +-> , <n> -+        |
    +-> FLOAT -+----------+------------------------+
    |          +-> (<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 --+

  interval-qualifier =

  --+-> YEAR ---> prec --+-------------+-----------------+->
    |                    +-> TO MONTH -+                 |
    +-> MONTH --> prec ----------------------------------+
    +-> DAY ----> prec --+-------------------------------+
    |                    +-> TO -+-> HOUR ---------------+
    |                            +-> MINUTE -------------+
    |                            +-> SECOND -> frac -----+
    +-> HOUR ---> prec --+-------------------------------+
    |                    +-> TO -+-> MINUTE -------------+
    |                            +-> SECOND -> frac -----+
    +-> MINUTE -> prec --+-------------------------------+
    |                    +-> TO SECOND ------> frac -----+
    +-> SECOND -> seconds-prec --------------------------+

  literal =

  --+-> numeric-literal ----+--->
    +-> string-literal -----+
    +-> date-time-literal --+
    +-> interval-literal ---+

  domain-constraint =

  --+----------------------------------------------------+---->
    +-> CHECK ( predicate ) -+--------------------------++
                             +-> constraint-attributes -+

  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 -+                   |
   +-> NO QUERY HEADER ---------------------------------------+
   +-> NO EDIT STRING ----------------------------------------+
   +-> NO QUERY NAME ----+--> FOR -+-> DTR --------+----------+
   +-> NO DEFAULT VALUE -+         +-> DATATRIEVE -+          |
   +-> COMMENT IS -+-> <quoted-string> -+---------------------+
                   +------ / <----------+
Close Help