DESCRIBE SEQUENCE¶

Describes a sequence, including the sequence’s interval.

DESCRIBE can be abbreviated to DESC.

See also:

ALTER SEQUENCE , CREATE SEQUENCE , DROP SEQUENCE , SHOW SEQUENCES

Syntax¶

DESC[RIBE] SEQUENCE <name>
Copy

Parameters¶

name

Specifies the identifier for the sequence to describe.

Usage notes¶

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

Examples¶

DESC SEQUENCE my_sequence;
Copy