SQL$HELP_OLD72.HLB  —  CREATE  SEQUENCE  Format
  CREATE SEQUENCE <sequence-name> ------------------+
  +--------------------<----------------------------+
  +---+---------------->-------------------------+--+
      +---> STORED NAME IS ----> <stored-name> --+  |
  +--------------------<----------------------------+
  +-+------------------>-------------------------+-->
    +-+-+---> sequence-attributes --------+-+----+
      | +---> START WITH <numeric-value> -+ |
      +------------------<------------------+

  sequence-attributes =

   --+--> INCREMENT BY <numeric-value> ---------+->
     +--> sequence-range -----------------------+
     +--> CYCLE --------------------------------+
     +--> NOCYCLE ------------------------------+
     +--> CACHE <numeric-value> ----------------+
     +--> NOCACHE ------------------------------+
     +--> ORDER --------------------------------+
     +--> NOORDER ------------------------------+
     +--> RANDOMIZE ----------------------------+
     +--> NORANDOMIZE --------------------------+
     +--> RESTART WITH -------------------------+
     +--> WAIT ---------------------------------+
     +--> NOWAIT -------------------------------+
     +--> DEFAULT WAIT -------------------------+
     +--> COMMENT -+-------+--+-> '<string>' -+-+
                   +-> IS -+  +------ / <-----+

  sequence-range =

  -+-> MINVALUE -+-+--> <numeric-value> -+--+-->
   +-> MAXVALUE -+ +--> TINYINT      ----+  |
   |               +--> SMALLINT      ---+  |
   |               +--> INTEGER      ----+  |
   |               +--> BIGINT      -----+  |
   +-> NOMINVALUE --------------------------+
   +-> NOMAXVALUE --------------------------+
Close Help