The Firebird 5.0 Language Reference | CREATE OR ALTER FUNCTION

Examples of `CREATE OR ALTER FUNCTION`

Create a new or alter an existing stored 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

Available in

DSQL

Syntax

DROP FUNCTION funcname

Table 1. `DROP FUNCTION` Statement Parameters
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.

Who Can Drop a Function

The DROP FUNCTION statement can be executed by:

Administrators
Owner of the stored function
Users with the DROP ANY FUNCTION privilege

Examples of `DROP FUNCTION`

DROP FUNCTION ADD_INT;

`RECREATE FUNCTION`

Drops a stored function if it exists, and creates a stored function

Available in

DSQL

Syntax

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 `COMMIT` phase of this operation.

After a procedure is successfully recreated, existing privileges to execute the stored function and theprivileges of the stored function itself are dropped.

Examples of `RECREATE FUNCTION`

Creating or recreating a stored function

RECREATE FUNCTION ADD_INT(A INT, B INT DEFAULT 0)
RETURNS INT
AS
BEGIN
  RETURN A + B;
EN

Examples Of CREATE OR ALTER FUNCTION

Examples of CREATE OR ALTER FUNCTION

DROP FUNCTION

Who Can Drop a Function

Examples of DROP FUNCTION

RECREATE FUNCTION

Examples of RECREATE FUNCTION

Examples of `CREATE OR ALTER FUNCTION`

`DROP FUNCTION`

Examples of `DROP FUNCTION`

`RECREATE FUNCTION`

Examples of `RECREATE FUNCTION`