DROP SEQUENCE

On this page Carat arrow pointing down
Warning:
CockroachDB v20.2 is no longer supported as of May 10, 2022. For more details, refer to the Release Support Policy.

The DROP SEQUENCE statement removes a sequence from a database.

Note:

This statement performs a schema change. For more information about how online schema changes work in CockroachDB, see Online Schema Changes.

Required privileges

The user must have the DROP privilege on the specified sequence(s).

Synopsis

DROP SEQUENCE IF EXISTS sequence_name , CASCADE RESTRICT
## Parameters Parameter | Description -----------|------------ `IF EXISTS` | Drop the sequence only if it exists; if it does not exist, do not return an error. `sequence_name` | The name of the sequence you want to drop. Find the sequence name with `SHOW CREATE` on the table that uses the sequence. `RESTRICT` | _(Default)_ Do not drop the sequence if any objects (such as [constraints](constraints.html) and tables) use it. `CASCADE` | Not yet implemented. Currently, you can only drop a sequence if nothing depends on it. ## Examples ### Remove a sequence (no dependencies) In this example, other objects do not depend on the sequence being dropped.
icon/buttons/copy
> CREATE SEQUENCE even_numbers INCREMENT 2 START 2;
icon/buttons/copy
> SHOW SEQUENCES;
  sequence_schema | sequence_name
------------------+----------------
  public          | even_numbers
(1 row)
icon/buttons/copy
> DROP SEQUENCE even_numbers;
icon/buttons/copy
> SHOW SEQUENCES;
  sequence_schema | sequence_name
------------------+----------------
(0 rows)

See also


Yes No
On this page

Yes No