Schema:
ACCOUNT_USAGE

SEQUENCES View

This Account Usage view displays a row for each sequence defined in the account.

Columns

Column Name Data Type Description
SEQUENCE_ID NUMBER Internal/system-generated identifier for the sequence.
SEQUENCE_NAME TEXT Name of the sequence.
SEQUENCE_SCMEHA_ID NUMBER Internal/system-generated identifier for the schema of the sequence.
SEQUENCE_SCHEMA TEXT Schema that the sequence belongs to.
SEQUENCE_CATALOG_ID NUMBER Internal/system-generated identifier for the database of the sequence.
SEQUENCE_CATALOG TEXT Database that the sequence belongs to.
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 Date and time when the sequence was created.
LAST_ALTERED TIMESTAMP_LTZ Date and time when the sequence was last altered.
DELETED TIMESTAMP_LTZ Date and time when the sequence was dropped.
COMMENT TEXT Comment for the sequence.

Usage Notes

  • Latency for the view may be up to 120 minutes (2 hours).
  • The view only displays objects for which the current role for the session has been granted access privileges.
  • The view does not recognize the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command executed by a user who holds the MANAGE GRANTS privilege.