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.

Auditing

Values in event and extrainfo columns of sysaudits are:

Event

Audit option

Command or access audited

Information in extrainfo

98

drop

drop function

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – NULL

  • Proxy information – Original login name, if a set proxy is in effect

See also

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

Commands create function (SQLJ)