SEQUENCE_ID

NUMBER

Internal/system-generated identifier for the sequence.

SEQUENCE_NAME

VARCHAR

Name of the sequence.

SEQUENCE_SCHEMA_ID

NUMBER

Internal/system-generated identifier for the schema of the sequence.

SEQUENCE_SCHEMA

VARCHAR

Schema that the sequence belongs to.

SEQUENCE_CATALOG_ID

NUMBER

Internal/system-generated identifier for the database of the sequence.

SEQUENCE_CATALOG

VARCHAR

Database that the sequence belongs to.

SEQUENCE_OWNER

VARCHAR

Name of the role that owns the sequence.

DATA_TYPE

VARCHAR

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

VARCHAR

Initial value of the sequence.

MINIMUM_VALUE

VARCHAR

Not applicable for Snowflake.

MAXIMUM_VALUE

VARCHAR

Not applicable for Snowflake.

NEXT_VALUE

VARCHAR

Next value that the sequence will produce.

INCREMENT

VARCHAR

Increment of the sequence generator.

CYCLE_OPTION

VARCHAR

Not applicable for Snowflake.

ORDERED

VARCHAR

If YES, the sequence has the ORDER property. If NO, the sequence has the NOORDER property.

CREATED

TIMESTAMP_LTZ

Date and time when the sequence was created.

LAST_ALTERED

TIMESTAMP_LTZ

Date and time the object was last altered by a DML, DDL, or background metadata operation. See Usage Notes.

DELETED

TIMESTAMP_LTZ

Date and time when the sequence was dropped.

COMMENT

VARCHAR

Comment for the sequence.

OWNER_ROLE_TYPE

VARCHAR

The type of role that owns the object, for example ROLE. . If a Snowflake Native App owns the object, the value is APPLICATION. . Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.