DROP SEQUENCE ​

Drop a sequence number generator.

DROP SEQUENCE [ IF EXISTS ] name [, ...]

IF EXISTS

When you use the IF EXISTS option, the command does not return a warning if the sequence does not exist.

name

One or more sequences to drop (optionally schema-qualified).

For example:

premdb=# drop sequence seq999, public.seq1000;
DROP SEQUENCE

Parent topic:SQL Commands