DROP_EVENT_TRIGGER(7pg16)

💅 DROP EVENT_TRIGGER 💅

okay so bestie, this is the DROP EVENT TRIGGER page from the PostgreSQL 16 docs — it's short, it's sweet, and it's about yeeting an event trigger into the void. let's get into it 🫶

---

✨ SYNOPSIS ✨

DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ]

that's the whole vibe. three little pieces, slay.

---

🎀 DESCRIPTION 🎀

DROP EVENT TRIGGER removes an existing event trigger. literally just deletes it. gone. no cap.

one tiny thing though — to actually run this command, the current user must be the owner of the event trigger. not your bestie, not your group chat, you. if it's not yours, the vibes are off and it won't work 🙈

---

🌸 PARAMETERS 🌸

• IF EXISTS — okay so this is the "don't be dramatic" flag. do not throw an error if the event trigger doesn't exist. instead a notice is issued in this case. so like, it'll tell you, but it won't scream at you 💀
• name — the name of the event trigger to remove. the one you're dropping. the main character of this operation 👑
• CASCADE — highkey the dangerous one. automatically drop objects that depend on the trigger, and in turn all objects that depend on those objects (see Section 5.14). it's giving domino effect. it's giving chain reaction. be sure before you commit, fr fr 🔥
• RESTRICT — the cautious icon. refuse to drop the trigger if any objects depend on it. and bestie, this is the default, so it's already looking out for you ✨

---

🦋 EXAMPLES 🦋

destroy the trigger snitch:

DROP EVENT TRIGGER snitch;

not the trigger being named snitch 😭 anyway — snitch is gone. periodt. 💅

---

⭐ COMPATIBILITY ⭐

there is no DROP EVENT TRIGGER statement in the SQL standard. so if you go looking for it in the standard, don't. it's a PostgreSQL thing. iykyk 🌈

---

💜 SEE ALSO 💜

• CREATE EVENT TRIGGER (CREATE_EVENT_TRIGGER(7)) — for when you wanna make one instead of destroy it
• ALTER EVENT TRIGGER (ALTER_EVENT_TRIGGER(7)) — for when you just wanna tweak it a lil

---

okay that's the page!! 🎀 this was PostgreSQL 16.15 documentation, dated 2026, and the manual name is DROP EVENT TRIGGER — go forth and drop responsibly, bestie 🧚💖