Skip to content

Instantly share code, notes, and snippets.

@anytizer

anytizer/drop-all-functions-of-database.sql

Created January 11, 2014 15:39
Show Gist options
  • Save anytizer/8372363 to your computer and use it in GitHub Desktop.
Save anytizer/8372363 to your computer and use it in GitHub Desktop.
Download ZIP
Drop all functions from 'your_database' database.
Raw
drop-all-functions-of-database.sql
SELECT
CONCAT('DROP FUNCTION ', `SPECIFIC_NAME`, ';') drop_function
FROM `INFORMATION_SCHEMA`.`ROUTINES`
WHERE
`ROUTINE_SCHEMA` = 'your_database'
AND ROUTINE_TYPE = 'FUNCTION'
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment