Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > CREATE SEQUENCE >

MAXVALUE or NOMAXVALUE Option

Use the MAXVALUE option to specify the upper limit of values in a sequence. The maximum value, or max, must be an integer in the INT8 range that is greater than the value of the origin.

If you do not specify a max value, the default is NOMAXVALUE. This default setting supports values that are less than or equal to 2e64 for ascending sequences, or less than or equal to -1 for descending sequences.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]