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.

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?