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.