DROP_EVENT_TRIGGER(7pg14)

💅 DROP EVENT TRIGGER 💅

okay so this is the DROP EVENT TRIGGER page straight out of the PostgreSQL 14.24 Documentation bestie, and it's genuinely one of the shorter ones so we can absolutely get through it together 🫶

---

🌸 NAME 🌸

DROP_EVENT_TRIGGER — remove an event trigger. that's it, that's the whole vibe. bye bye trigger 👋

---

✨ SYNOPSIS ✨

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

look at her. so clean. so iconic. no notes 💅

---

🦋 DESCRIPTION 🦋

DROP EVENT TRIGGER removes an existing event trigger. lowkey the whole point of the command ngl.

but here's the catch bestie — to execute this command, the current user must be the owner of the event trigger. no ownership, no dropping. that's the rules 😭

---

🎀 PARAMETERS 🎀

• IF EXISTS — Do not throw an error if the event trigger does not exist. A notice is issued in this case. like, it's giving "no drama, we move" energy 💅
• name — The name of the event trigger to remove. literally just the name, girl, that's it ✨
• CASCADE — 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 chain reaction, main character energy, everything comes down with it 🔥
• RESTRICT — Refuse to drop the trigger if any objects depend on it. This is the default. she's cautious, she's careful, she's the responsible friend 🧚

---

🌈 EXAMPLES 🌈

Destroy the trigger snitch:

DROP EVENT TRIGGER snitch;

not the snitch getting obliterated 😭💀 honestly deserved. periodt.

---

👑 COMPATIBILITY 👑

There is no DROP EVENT TRIGGER statement in the SQL standard.

ngl that's kinda the whole story — the SQL standard simply does not have her. she's built different, a PostgreSQL original 🦋

---

💜 SEE ALSO 💜

• CREATE EVENT TRIGGER (CREATE_EVENT_TRIGGER(7))
• ALTER EVENT TRIGGER (ALTER_EVENT_TRIGGER(7))

like the full trilogy fr fr — make her, change her, drop her 💅✨

---

and that's the page!! brought to you by PostgreSQL 14.24, dated 2026, DROP EVENT TRIGGER(7) — go forth and drop responsibly bestie 🫶🎀🌸