Sign InTry Free

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

Download PDF
Products
TiDB Cloud
TiDB
Pricing
Get Demo
© 2023 PingCAP. All Rights Reserved.