The syntax for SQL SEQUENCE is as follows:
CREATE SEQUENCE [schema.]sequence_name
[ AS datatype ]
[ START WITH value ]
[ INCREMENT BY value ]
[ MINVALUE value | NO MINVALUE ]
[ MAXVALUE value | NO MAXVALUE ]
[ CYCLE | NO CYCLE ]
[ CACHE value | NO CACHE ];
It can be TINYINT, INT, BIGINT, SMALLINT, NUMERIC or DECIMAL. On the off chance that datatype is not determined, the grouping will default to a BIGINT datatype.
The beginning esteem that the succession returns at first.
It can be neither a negative or positive quality. On the off chance that a positive worth is indicated, the succession will be a rising grouping of qualities. On the off chance that a negative worth is determined, the succession will be a diving grouping of qualities.
The base worth took into account the grouping.
It implies that there is no base quality determined for the grouping.
The most extreme quality took into account the arrangement.
It implies that there is no most extreme quality indicated for the grouping.
It implies that the arrangement will begin once again once it has finished the grouping.
It implies that the arrangement will raise a blunder when it has finished the grouping. It won't begin the succession once again once more.
It stores the succession numbers to minimize plate IO.
It doesn't reserve the grouping numbers.