SHOW CREATE SEQUENCE

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

Synopsis

ShowStmt:

ShowStmt

TableName:

TableName

Examples

CREATE TABLE 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

Currently, MySQL does not have the sequence option. The TiDB sequence is borrowed from MariaDB. Except for the SETVAL function, all other functions have the same progressions with those functions of MariaDB.

See also