On this page
Warning:
As of October 4, 2019, CockroachDB v2.0 is no longer supported. For more details, refer to the Release Support Policy.
New in v2.0: The SHOW CREATE SEQUENCE
statement shows the CREATE SEQUENCE
statement that would create a copy of the specified sequence.
Required Privileges
The user must have any privilege on the target sequence.
Synopsis
Parameters
Parameter | Description |
---|---|
sequence_name |
The name of the sequence for which to show the CREATE SEQUENCE statement. |
Response
Field | Description |
---|---|
Sequence |
The name of the sequence. |
CreateSequence |
The CREATE SEQUENCE statement for creating a copy of the specified sequence. |
Example
> CREATE SEQUENCE desc_customer_list START -1 INCREMENT -2;
> SHOW CREATE SEQUENCE desc_customer_list;
+--------------------+----------------------------------------------------------------------------------------------------+
| Sequence | CreateSequence |
+--------------------+----------------------------------------------------------------------------------------------------+
| desc_customer_list | CREATE SEQUENCE desc_customer_list MINVALUE -9223372036854775808 MAXVALUE -1 INCREMENT -2 START -1 |
+--------------------+----------------------------------------------------------------------------------------------------+