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

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

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


Commands   create function (SQLJ)









Copyright © 2011. Sybase Inc. All rights reserved.








View this document as PDF