SEQUENCES (Transact-SQL)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database YesAzure SQL Managed Instance

Returns one row for each sequence that can be accessed by the current user in the current database.

To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA.view_name.

Column name Data type Description
SEQUENCE_CATALOG nvarchar(128) Sequence qualifier
SEQUENCE_SCHEMA **nvarchar(128) Name of schema that contains the sequence
SEQUENCE_NAME nvarchar(128) Sequence name
DATA_TYPE nvarchar(128) The sequence data type
NUMERIC_PRECISION tinyint The precision of the sequence
NUMERIC_PRECISION_RADIX smallint Precision radix of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, NULL is returned.
NUMERIC_SCALE int Scale of approximate numeric data, exact numeric data, integer data, or monetary data. Otherwise, NULL is returned.
START_VALUE int The first value that will be returned by the sequence object.
MINIMUM_VALUE int The bounds for the sequence object. The default minimum value for a new sequence object is the minimum value of the data type of the sequence object. This is zero for the tinyint data type and a negative number for all other data types.
MAXIMUM_VALUE int The bounds for the sequence object. The default maximum value for a new sequence object is the maximum value of the data type of the sequence object.
INCREMENT int Value used to increment (or decrement if negative) the value of the sequence object for each call to the NEXT VALUE FOR function. If the increment is a negative value, the sequence object is descending; otherwise, it is ascending. The increment cannot be 0. The default increment for a new sequence object is 1.
CYCLE_OPTION int Property that specifies whether the sequence object should restart from the minimum value (or maximum for descending sequence objects) or throw an exception when its minimum or maximum value is exceeded. The default cycle option for new sequence objects is NO CYCLE.
DECLARED_DATA_TYPE int The data type for user-defined data type.
DECLARED_DATA_PRECISION int The precision for user-defined data type.
DECLARED_NUJMERIC_SCALE int The numeric scale for user-defined data type.

Example The following example, returns information about the schemas in the test database:

SELECT * FROM test.INFORMATION_SCHEMA.SEQUENCES;

See Also