Categories:

Table, View, & Sequence DDL

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>

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;