Important

You are viewing the documentation of TiDB v6.0 (DMR). PingCAP does not provide bug fixes for v6.0. Any bugs will be fixed in future releases.

For general purposes, please use the latest LTS version of the TiDB database.

SHOW CREATE SEQUENCE

The SHOW CREATE SEQUENCE shows the detailed information of a sequence, which is similar to SHOW CREATE TABLE.

Synopsis

ShowCreateSequenceStmt:

ShowCreateSequenceStmt

TableName:

TableName

Examples

CREATE SEQUENCE seq;
Query OK, 0 rows affected (0.03 sec)
SHOW CREATE SEQUENCE seq;
+-------+----------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                               |
+-------+----------------------------------------------------------------------------------------------------------------------------+
| seq   | CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 cache 1000 nocycle ENGINE=InnoDB |
+-------+----------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MySQL compatibility

This statement is a TiDB extension. The implementation is modeled on sequences available in MariaDB.

See also

Was this page helpful?