Products
High-quality database products to meet full lifecycle enterprise data management needs.
Resources
Various types of resources about OceanBase and the database industry
Docs
Rich content to meet the content demands of using products and solving product usage problems
OceanBase Database
Download PDF
OceanBase, A Highly Scalable Database for Transactional, Analytical, and AI Workloads.
Resources
© OceanBase 2024. All rights reserved | Cloud Service Agreement | Privacy Policy | Legal | Security
OceanBase DatabaseYou can use this statement to drop a sequence.
DROP SEQUENCE [schema. ] sequence_name;
| Parameter | Description |
|---|---|
| schema. | The schema where the sequence to be dropped is located. If schema. is not specified, the sequence to be dropped is located in the schema of the currently logged-on user. |
| sequence_name | The name of the sequence to be dropped. |
Drop the sequence named seq1.
obclient> DROP SEQUENCE seq1;
Query OK, 0 rows affected