SEQUENCES (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure 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;