DROP SEQUENCE statement drops the sequence object in TiDB.
DROP SEQUENCE seq;
Query OK, 0 rows affected (0.10 sec)
DROP SEQUENCE seq, seq2;
Query OK, 0 rows affected (0.03 sec)
Currently, MySQL does not have the sequence option. The TiDB sequence is borrowed from MariaDB. Except for the
SETVAL function, all other functions have the same progressions with those functions of MariaDB.