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.