DROP SEQUENCE

The DROP SEQUENCE statement drops the sequence object in TiDB.

Synopsis

DropSequenceStmt
DROPSEQUENCEIfExistsTableNameList
IfExists
IFEXISTS
TableNameList
TableName,
TableName
Identifier.Identifier

Examples

DROP SEQUENCE seq;
Query OK, 0 rows affected (0.10 sec)
DROP SEQUENCE seq, seq2;
Query OK, 0 rows affected (0.03 sec)

MySQL compatibility

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

See also

Was this page helpful?