DROP_SEQUENCE(7pg15)

🎀 NAME 🎀

okay so bestie, this is the DROP SEQUENCE(7) page — yep, the DROP_SEQUENCE(7pg15) one — and its whole personality is: DROP_SEQUENCE — remove a sequence. that's it. that's the name. periodt 💅

✨ SYNOPSIS ✨

copy this exactly, no freestyling:

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

🦋 DESCRIPTION 🦋

DROP SEQUENCE removes sequence number generators. the vibe is deletion, but with rules: a sequence can only be dropped by its owner or a superuser. no cap, those are the permissions. 🔥

💖 PARAMETERS 💖

• IF EXISTS — do not throw an error if the sequence does not exist. in that case, a notice is issued. so it's a notice, not an error — important distinction, bestie. ✨
• name — the name of a sequence, and it can be optionally schema-qualified. yes, schema-qualified is allowed. 💅
• 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 domino effect. 🌈
• RESTRICT — refuse to drop the sequence if any objects depend on it. This is the default. so yeah, default behavior is protective. 💜

🔥 EXAMPLES 🔥

to remove the sequence serial, you literally run:

DROP SEQUENCE serial;

slay. ✨

🌈 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. that's the compatibility tea. 🍓

👑 SEE ALSO 👑

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

---

mwah 💋 — source/version + date check: PostgreSQL 15.19 Documentation, dated 2026. bye bestie, go be iconic with your sequences 🫶💅