On this page 
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 |
+--------------------+----------------------------------------------------------------------------------------------------+
See Also
Was this helpful?
