Examples of CREATE OR ALTER FUNCTION
CREATE OR ALTER FUNCTION ADD_INT(A INT, B INT DEFAULT 0) RETURNS INT AS BEGIN RETURN A + B; END
CREATE OR ALTER FUNCTION
CREATE OR ALTER FUNCTION ADD_INT(A INT, B INT DEFAULT 0) RETURNS INT AS BEGIN RETURN A + B; END
DROP FUNCTION
Drops a stored function
DSQL
DROP FUNCTION funcname
Parameter | Description |
---|---|
funcname |
Stored function name.The maximum length is 63 characters.Must be unique among all function names in the database. |
The DROP FUNCTION
statement deletes an existing stored function.If the stored function has any dependencies, the attempt to delete it will fail, and raise an error.
The DROP FUNCTION
statement can be executed by:
Owner of the stored function
Users with the DROP ANY FUNCTION
privilege
DROP FUNCTION
DROP FUNCTION ADD_INT;