ASA SQL User's Guide
  Accessing Remote Data
    Using remote procedure calls (RPCs)

Dropping remote procedures

You can delete a remote procedure using either Sybase Central or the DROP PROCEDURE statement.

You must have DBA authority to delete a remote procedure.

To delete a remote procedure (Sybase Central)

1. Open the Remote Servers folder.

2. In the left pane, select the remote server.

3. In the right pane, click the Remote Procedures tab.

4. On the Remote Procedures tab, right-click the remote procedure and choose Delete from the popup menu.

To delete a remote procedure (SQL)

1. Connect to a database.

2. Execute a DROP PROCEDURE statement.

For more information, see DROP statement.

Example 

Delete a remote procedure called remoteproc.

DROP PROCEDURE remoteproc