drop function (SQLJ)

Syntax

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

Example 1 – Removes the SQLJ function square_root:
```
drop function square_root
```

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

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

The permission checks for drop function (SQLJ) differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the function owner or a user with `drop any function` privilege.
Disabled	With granular permissions disabled, you must be the function owner or a user with sa_role. Permissions are not transferable.

Values in event and extrainfo columns of sysaudits are:

Information	Values
Event	98
Audit option	drop
Command or access audited	drop function
Information in `extrainfo`	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