DROP_SEQUENCE(7pg16)

💖 DROP SEQUENCE — the pg16 manual page 💖

okay so bestie, welcome to the DROP SEQUENCE page from the PostgreSQL 16.15 Documentation — yes, the pg16 one. We're gonna yeet sequence number generators, but make it make sense 💅.

---

✨ NAME ✨

DROP_SEQUENCE — remove a sequence. That's the whole vibe. A sequence is getting removed, periodt 🎀.

🦋 SYNOPSIS 🦋

DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

🌸 DESCRIPTION 🌸

DROP SEQUENCE removes sequence number generators — like, actually removes them, not just gives them a time-out 😭.

A sequence can only be dropped by its owner or a superuser. No random bestie off the street can just drop it. Respect the hierarchy 👑.

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the sequence does not exist. A notice is issued in this case. So it's giving "no drama, just a little heads-up" 💌.
• name — the name (optionally schema-qualified) of a sequence. Yes, schema-qualified is allowed, slay 🫶.
• CASCADE — automatically drop objects that depend on the sequence, and in turn all objects that depend on those objects (see Section 5.14). It's giving chain reaction energy 🔥.
• RESTRICT — refuse to drop the sequence if any objects depend on it. This is the default. Very "nope, not until you deal with your dependencies" 💀.

🍓 EXAMPLES 🍓

To remove the sequence serial:

DROP SEQUENCE serial;

Short, iconic, done 😌.

🌈 COMPATIBILITY 🌈

DROP SEQUENCE conforms to the SQL standard, except that the standard only allows one sequence to be dropped per command, and apart from the IF EXISTS option, which is a PostgreSQL extension. So yes, mostly standard behavior, with a lil PostgreSQL flair ✨.

💜 SEE ALSO 💜

• CREATE SEQUENCE (CREATE_SEQUENCE(7))
• ALTER SEQUENCE (ALTER_SEQUENCE(7))

---

mwah 💋 — this page is from PostgreSQL 16.15, dated 2026, and it's the DROP SEQUENCE(7) page. periodt 💅🎀