DROP FUNCTION
You are viewing an old version of this article. View
the current version here.
Syntax
DROP FUNCTION [IF EXISTS] f_name
Contents
Description
The DROP FUNCTION
statement is used to drop a stored function or a user-defined function (UDF). That is, the
specified routine is removed from the server. You must have the
ALTER ROUTINE
privilege for the routine. If the automatic_sp_privileges server system variable is set, that privilege and EXECUTE
are
granted automatically to the routine creator - see Stored Routine Privileges.
IF EXISTS
The IF EXISTS
clause is a MySQL/MariaDB extension. It
prevents an error from occurring if the function does not exist. A
NOTE
is produced that can be viewed with SHOW WARNINGS.
For dropping a user-defined functions (UDF), see DROP FUNCTION UDF.
See also
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.