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

SHOW CREATE SEQUENCE sequence_name

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



Yes No