Deleting a Procedure, Table UDF, or TPF

Remove a procedure, remote procedure, Table UDF, or TPF from an SAP Sybase IQ server.

Prerequisites

Database Version	Procedure Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. You own the procedure.
SAP Sybase IQ 16.0	Requires one of: DROP ANY PROCEDURE system privilege. DROP ANY OBJECT system privilege. You own the procedure.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Compiled Objects > Procedures.
Select one or more procedures, remote procedures, Table UDFs or TPFs 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 procedures.
Click Yes to confirm the deletion.