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 | +--------------------+----------------------------------------------------------------------------------------------------+