You can use the DROP SEQUENCE statement to drop a sequence.
The SQL syntax for dropping a sequence is as follows:
DROP SEQUENCE [IF EXISTS] [database_name.]sequence_name;
Instructions for using the statement:
To execute this statement, you must have the
DROPprivilege.If
IF EXISTSis specified, no error is returned even if the sequence to be dropped does not exist. If it is not specified, the system returns an error.database_name.specifies the database where the sequence is located. Ifdatabase_name.is not specified, the sequence in the current login database is used by default.
The following example drops a sequence named S1:
obclient> DROP SEQUENCE S1;
Query OK, 0 rows affected
For more information about the DROP SEQUENCE statement, see DROP SEQUENCE.
References
For more information about sequences, see the following topics: