Deleting a Function
Remove a function from an SAP Sybase IQ server.
Prerequisites
Database Version
Function Privileges
SAP Sybase IQ 15.3 and 15.4
You must have one of:
DBA authority
You own the function
SAP Sybase IQ
16.0
You must have one of:
DROP ANY PROCEDURE system privilege
DROP ANY OBJECT system privilege
You own the function
The SAP Sybase IQ resource is authenticated and running.
Task
In the Perspective Resources view, select the resource, and select
Resource
>
Administration Console
.
In the left pane, expand
IQ Servers
>
Compiled Objects
, and then select
Functions
.
Select one or more functions from the right pane and either:
Click the arrow to the right of the name and select
Delete
, or
From the Administration Console menu bar, select
Resource
>
Delete
.
Tip:
Use
Shift-click
or
Control-click
to select multiple functions.
Click
Yes
to confirm deletion.
Parent topic:
Functions
Related tasks
Creating a Watcom SQL or Transact-SQL Function
Creating an External Java Function
Creating an External C/C++ Scalar or Aggregate Function
Generating Function DDL Commands
Viewing and Modifying a Function
Granting Function EXECUTE Permission
Revoking Function EXECUTE Permission
Authenticating a Login Account for a Managed Resource
Related reference
Function Privilege Summary
Created November 21, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com