DROP SEQUENCE

+2
y
T
C
q

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

DROP SEQUENCEwas last updated 2/11/2022, 3:01:49 AM: Remove aliases from v5.4 (#7559)

Was this page helpful?