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 You must have one of:
  • DBA authority
  • You own the procedure
SAP Sybase IQ 16.0 You must have one of:
  • DROP ANY PROCEDURE system privilege
  • DROP ANY OBJECT system privilege
  • You own the procedure
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Compiled Objects, and then select Procedures.
  3. 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.
  4. Click Yes to confirm the deletion.
Related tasks
Creating a Procedure
Creating a Remote Procedure
Creating a Table UDF or TPF
Executing a Procedure, Table UDF, or TPF using View Data in SQL
Generating Procedure, Table UDF, or TPF DDL Commands
Viewing or Modifying a Procedure, Table UDF, or TPF
Granting Procedure EXECUTE Permission
Revoking Procedure EXECUTE Permission
Authenticating a Login Account for a Managed Resource
Related reference
Procedure Privilege Summary