{"id":2252,"date":"2019-06-21T03:13:22","date_gmt":"2019-06-21T10:13:22","guid":{"rendered":"https:\/\/oracletutorial.com\/?page_id=2252"},"modified":"2025-05-03T15:32:31","modified_gmt":"2025-05-03T22:32:31","slug":"oracle-drop-sequence","status":"publish","type":"page","link":"https:\/\/www.oracletutorial.com\/oracle-sequence\/oracle-drop-sequence\/","title":{"rendered":"Oracle DROP SEQUENCE"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the Oracle DROP SEQUENCE<\/code> statement to remove a sequence from the database.<\/p>\n\n\n\n

Oracle DROP SEQUENCE overview #<\/a><\/h2>\n\n\n\n

The DROP SEQUENCE<\/code> statement allows you to remove a sequence from the database.<\/p>\n\n\n\n

Here is the basic syntax of the DROP SEQUENCE<\/code> statement:<\/p>\n\n\n

DROP<\/span> SEQUENCE<\/span> schema_name.sequence_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, specify the name of the sequence that you want to remove after the DROP SEQUENCE<\/code> keywords.<\/p>\n\n\n\n
If you don’t specify the schema to which the sequence belongs, Oracle will remove the sequence in your own schema.<\/p>\n\n\n\n
The sequence that you remove must be in your own schema or you need to have the DROP ANY SEQUENCE<\/code> system privilege to remove a sequence in any schema.<\/p>\n\n\n\n
The DROP SEQUENCE<\/code> statement is also useful in case you want to restart a sequence.<\/p>\n\n\n\n
For example, if you have a sequence with the current value of 100 and you want to restart the sequence with a value of 50, then you can drop the sequence and re-create it with a START VALUE<\/code> of 50.<\/p>\n\n\n\n
Oracle DROP SEQUENCE example #<\/a><\/h2>\n\n\n\n
This statement creates a new sequence<\/a> called no_seq<\/code>:<\/p>\n\n\n
CREATE<\/span> SEQUENCE<\/span> no_seq;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
To remove the no_seq<\/code> from the database, you use the following statement:<\/p>\n\n\n
DROP<\/span> SEQUENCE<\/span> no_seq;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this tutorial, you have learned how to use the Oracle DROP SEQUENCE<\/code> statement to remove a sequence from the database.<\/p>\n\n\n\n
Quiz #<\/a><\/h2>\n\n\n\n