Dropping remote procedures

Use one of the following procedures to delete a remote procedure.

To delete a remote procedure (Sybase Central)

  1. Connect to the database as a user with DBA authority.

  2. In the left pane, double-click Remote Servers.

  3. Select the remote server, and in the right pane click the Remote Procedures tab.

  4. Select the remote procedure, and then choose File » Delete.

  5. Click Yes.

To delete a remote procedure (SQL)

  1. Connect to the database as a user with DBA authority.

  2. Execute a DROP PROCEDURE statement.

For more information, see DROP statement.

Example

Delete a remote procedure called remoteproc.

DROP PROCEDURE remoteproc;