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

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


Granular permissions enabled


With granular permissions enabled, you
must be the function owner or a user with drop any function privilege. 



Granular permissions disabled 


With granular permissions disabled, you
must be the function owner or a user with sa_role. 

Permissions are not transferable. 





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 © 2012. Sybase Inc. All rights reserved.








View this document as PDF