Use the START WITH option to specify the first number of the sequence. This origin value must be an integer within the INT8 range that is greater than or equal to the min value (for an ascending sequence) or that is less than or equal to the max value (for a descending sequence), if min or max is specified in the CREATE SEQUENCE statement. The WITH keyword is optional.
If you do not specify an origin value, the default initial value is min for an ascending sequence or max for a descending sequence. (The MAXVALUE or NOMAXVALUE Option and MINVALUE or NOMINVALUE Option sections that follow describe the max and min specifications respectively.)
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]