DROP_ROUTINE(7pg13)

💅 DROP ROUTINE 💅

okay bestie, so this is the DROP ROUTINE page from the PostgreSQL 13.23 docs — yes, that's the manual this little beauty lives in, DROP_ROUTINE(7). buckle up 🎀

---

✨ NAME ✨

DROP_ROUTINE — remove a routine 🗑️✨

---

🌸 SYNOPSIS 🌸

DROP ROUTINE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...]
    [ CASCADE | RESTRICT ]

like, look at all those optional brackets. she's flexible. she contains multitudes. 🫶

---

💖 DESCRIPTION 💖

so DROP ROUTINE removes the definition of an existing routine. and "routine" here is a whole umbrella term — it can be an aggregate function, a normal function, or a procedure. one command, three vibes, no cap 👑

but here's the thing — the actual descriptions of the parameters, the juicier examples, and all the further details live under their own pages:

• DROP AGGREGATE (DROP_AGGREGATE(7))
• DROP FUNCTION (DROP_FUNCTION(7))
• DROP PROCEDURE (DROP_PROCEDURE(7))

so if you want the full tea, go read those. iykyk 💅

---

🦋 EXAMPLES 🦋

wanna drop the routine foo for type integer? say less:

DROP ROUTINE foo(integer);

and the iconic part?? this command works independent of whether foo is an aggregate, a function, or a procedure. she does not care. she does not ask questions. she just drops 🔥

---

⭐ COMPATIBILITY ⭐

this command conforms to the SQL standard — cute! — but with these PostgreSQL extensions, bestie:

• the standard only allows one routine to be dropped per command. we said "what if... more though" 💀
• the IF EXISTS option
• the ability to specify argument modes and names
• aggregate functions are an extension

---

🌈 SEE ALSO 🌈

• DROP AGGREGATE (DROP_AGGREGATE(7))
• DROP FUNCTION (DROP_FUNCTION(7))
• DROP PROCEDURE (DROP_PROCEDURE(7))
• ALTER ROUTINE (ALTER_ROUTINE(7))

ok real talk — note that there is no CREATE ROUTINE command. 😭 she drops, she does not create. main character energy only.

---

and that's the whole page, bestie! 🌸 this little masterpiece is from PostgreSQL 13.23, dated 2025 — go forth and drop responsibly 💜🧚✨