DBMSSQL

what is a sequence

SEQUENCES

A sequence is a database object used to generate sequence numbers for rows in table. It can be used for producing unique primary key values.

A sequence is created using CREATE SEQUENCE command. It has the following syntax:

CREATE SEQUENCE <sequence name> [INCREMENT BY <N>] [START WITH <N>] [MINVALUE X] [MAXVALUE];

Show More

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also
Close
Back to top button