| --- |
| title: DROP SEQUENCE |
| --- |
| |
| Removes a sequence. |
| |
| ## Synopsis<a id="topic1__section2"></a> |
| |
| ``` pre |
| DROP SEQUENCE [IF EXISTS] name [, ...] [CASCADE | RESTRICT] |
| ``` |
| |
| ## Description<a id="topic1__section3"></a> |
| |
| `DROP SEQUENCE` removes a sequence generator table. You must own the sequence to drop it (or be a superuser). |
| |
| ## Parameters<a id="topic1__section4"></a> |
| |
| IF EXISTS |
| Do not throw an error if the sequence does not exist. A notice is issued in this case. |
| |
| *name* |
| The name (optionally schema-qualified) of the sequence to remove. |
| |
| CASCADE |
| Automatically drop objects that depend on the sequence. |
| |
| RESTRICT |
| Refuse to drop the sequence if any objects depend on it. This is the default. |
| |
| ## Examples<a id="topic1__section5"></a> |
| |
| Remove the sequence `myserial`: |
| |
| ``` pre |
| DROP SEQUENCE myserial; |
| ``` |
| |
| ## Compatibility<a id="topic1__section6"></a> |
| |
| `DROP SEQUENCE` is fully conforming with the SQL standard, except that the standard only allows one sequence to be dropped per command. Also, the `IF EXISTS` option is a HAWQ extension. |
| |
| ## See Also<a id="topic1__section7"></a> |
| |
| /3/4 |