SQL statements for designing and managing routines

SQL statement	Function
CREATE PROCEDURE	Creates a procedure
CREATE FUNCTION	Creates a User Defined Function (UDF)
COMPOUND statement, CASE, FOR, IF, ITERATE, LEAVE, LOOP, REPEAT, RETURN, SET, WHILE	Control statements for a routine (in the CREATE PROCEDURE or CREATE FUNCTION statement)
GET DIAGNOSTICS; SIGNAL; RESIGNAL	Diagnostic statements for a routine (in the CREATE PROCEDURE or CREATE FUNCTION statement)
DROP PROCEDURE	Deletes a procedure
DROP Function	Deletes a User Defined Function (UDF)

Table 23: SQL statements for designing and managing routines