drop function (SQLJ)

Description

Removes a SQLJ function.

Syntax

drop func[tion] [owner.]function_name
	[, [owner.]function_name ] ...

Parameters

[owner.]function_name

is the SQL name of a SQLJ function.

Examples

Example 1

Removes the SQLJ function square_root:

drop function square_root

Usage

drop function removes only user-created functions from the current database. It does not remove system functions.

Permissions

Only the Database Owner or user with the sa role can execute drop function.

See also

Documents See Java in Adaptive Server Enterprise for more information about SQLJ functions.

Commands create function (SQLJ)