SEQUENCES View¶
This Information Schema view displays a row for each sequence defined in the specified (or current) database.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
SEQUENCE_CATALOG |
TEXT |
Database that the sequence belongs to |
SEQUENCE_SCHEMA |
TEXT |
Schema that the sequence belongs to |
SEQUENCE_NAME |
TEXT |
Name of the sequence |
SEQUENCE_OWNER |
TEXT |
Name of the role that owns the sequence |
DATA_TYPE |
TEXT |
Data type of the sequence |
NUMERIC_PRECISION |
NUMBER |
Numeric precision of the data type of the sequence |
NUMERIC_PRECISION_RADIX |
NUMBER |
Radix of the numeric precision of the data type of the sequence |
NUMERIC_SCALE |
NUMBER |
Scale of the data type of the sequence |
START_VALUE |
TEXT |
Initial value of the sequence |
MINIMUM_VALUE |
TEXT |
Not applicable for Snowflake. |
MAXIMUM_VALUE |
TEXT |
Not applicable for Snowflake. |
NEXT_VALUE |
TEXT |
Next value that the sequence will produce |
INCREMENT |
TEXT |
Increment of the sequence generator |
CYCLE_OPTION |
TEXT |
Not applicable for Snowflake. |
CREATED |
TIMESTAMP_LTZ |
Creation time of the sequence |
LAST_ALTERED |
TIMESTAMP_LTZ |
Last altered time of the sequence |
COMMENT |
TEXT |
Comment for this sequence |
Usage Notes¶
The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command when both are executed by a user who holds the MANAGE GRANTS privilege.