Doc Menu

DROP SEQUENCE

The DROP SEQUENCE statement drops the sequence object in TiDB.

Synopsis

DropSequenceStmt:

DropSequenceStmt

IfExists:

IfExists

TableNameList:

TableNameList

TableName:

TableName

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