DROP SEQUENCE
Function
DROP SEQUENCE deletes a sequence from the current database.
Precautions
- Only the owner of a sequence, the owner of the schema of the sequence, or users granted with the DROP permission on the sequence can delete the sequence. By default, the system administrator has the permission to delete the sequence.
- If the LARGE identifier is used when a sequence is created, the LARGE identifier must be used when the sequence is dropped.
Syntax
DROP [ LARGE ] SEQUENCE [ IF EXISTS ] {[schema.]sequence_name} [ , ... ] [ CASCADE | RESTRICT ];
Parameter Description
- IF EXISTS
Reports a notice instead of an error if the specified sequence does not exist.
- name
Specifies the name of the sequence to be deleted.
- CASCADE
Automatically deletes the objects that depend on the sequence.
- RESTRICT
Refuses to delete the sequence if any objects depend on it. This is the default action.
Examples
-- Create an ascending sequence named serial, starting from 101. openGauss=# CREATE SEQUENCE serial START 101; -- Delete a sequence. openGauss=# DROP SEQUENCE serial;
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot