DROP FUNCTION

Advantage SQL Engine

Removes a function from the database.

Syntax

DROP FUNCTION [package_name.]function_name

 

package_name ::= identifier

function_name ::= identifier

 

Remark

The DROP FUNCTION statement is used to remove a function from the database.

To remove a function that is not owned by any package, the user must have the DROP permission over the function. To remove a function that is owned by a package, the user must have the ALTER permission over the package.

Example

DROP FUNCTION test1;

DROP FUNCTION TestPack.test1;

 

See Also

ALTER FUNCTION

CREATE FUNCTION

CREATE PACKAGE

DROP PACKAGE

Effective Permissions