sequences

The sequences view provides information about all sequences in the database.

Column name	Data type	Description
sequence_catalog	sql_identifier	The name of the current database containing the sequence.
sequence_schema	sql_identifier	The name of the schema containing the sequence.
sequence_name	sql_identifier	The name of the sequence.
data_type	character_data	The data type of the sequence.
numeric_precision	cardinal_number	The declared or implicit precision of the sequence data type. Specifies the number of significant digits (decimal or binary), depending on numeric_precision_radix.
numeric_precision_radix	cardinal_number	Indicates the base (2 or 10) used for interpreting numeric_precision and numeric_scale.
numeric_scale	cardinal_number	The declared or implicit scale of the sequence data type. Indicates digits to the right of the decimal point (decimal or binary), depending on numeric_precision_radix.
start_value	character_data	The start value of the sequence.
minimum_value	character_data	The minimum value of the sequence.
maximum_value	character_data	The maximum value of the sequence.
increment	character_data	The increment of the sequence.
cycle_option	yes_or_no	Specifies whether the sequence cycles (YES) or not (NO).