DROP_SEQUENCE(7pg14)

okay bestie, this is the DROP_SEQUENCE(7pg14) page — manual name folded in near the top, just like we like it — and we’re talking about removing sequences in the PostgreSQL 14.24 docs. Buckle up, it’s giving concise but iconic 💖

🌸 NAME 🌸

DROP_SEQUENCE — remove a sequence 💅

✨ SYNOPSIS ✨

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

🦋 DESCRIPTION 🦋

okay so DROP SEQUENCE removes sequence number generators. The vibe check is simple: a sequence can only be dropped by its owner or a superuser. no cap, that’s the rule 👑

🎀 PARAMETERS 🎀

• 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 a sequence ✨
• CASCADE — automatically drop objects that depend on the sequence, and in turn all objects that depend on those objects (see Section 5.14) 🌀
• RESTRICT — refuse to drop the sequence if any objects depend on it. This is the default 🛑

🍓 EXAMPLES 🍓

To remove the sequence serial:

DROP SEQUENCE serial;

🌈 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. periodt 💫

💜 SEE ALSO 💜

• CREATE SEQUENCE (CREATE_SEQUENCE(7)) — go make a sequence, bestie 🫶
• ALTER SEQUENCE (ALTER_SEQUENCE(7)) — go change one up 🌟

💖 cute sign-off time: source/version is PostgreSQL 14.24, dated 2026 — bye bestie, go slay your sequences 💅✨