Examples of DROP FUNCTION
DROP FUNCTION ADD_INT;
DROP FUNCTION
DROP FUNCTION ADD_INT;
RECREATE FUNCTION
Drops a stored function if it exists, and creates a stored function
DSQL
RECREATE FUNCTION funcname
[ ( [ <in_params> ] ) ]
RETURNS <domain_or_non_array_type> [COLLATE collation]
[DETERMINISTIC]
{<psql_function> | <external-module-body>}
!! See syntax of CREATE FUNCTION
for further rules !!
The RECREATE FUNCTION
statement creates a new stored function or recreates an existing one.If there is a function with this name already, the engine will try to drop it and then create a new one.Recreating an existing function will fail at COMMIT
if the function has dependencies.
Note
|
Be aware that dependency errors are not detected until the |
After a procedure is successfully recreated, existing privileges to execute the stored function and theprivileges of the stored function itself are dropped.
RECREATE FUNCTION
RECREATE FUNCTION ADD_INT(A INT, B INT DEFAULT 0)
RETURNS INT
AS
BEGIN
RETURN A + B;
EN