ASA SQL User's Guide
  Accessing Remote Data
    Working with remote servers

Deleting remote servers

You can use Sybase Central or a DROP SERVER statement to delete a remote server from the Adaptive Server Anywhere system tables. All remote tables defined on that server must already be dropped for this action to succeed.

You must have DBA authority to delete a remote server.

To delete a remote server (Sybase Central)

1. Connect to the host database from Sybase Central.

2. Open the Remote Servers folder.

3. Right-click the remote server you want to delete and choose Delete from the popup menu.

To delete a remote server (SQL)

1. Connect to the host database from Interactive SQL.

2. Execute a DROP SERVER statement.

For more information, see DROP SERVER statement.

Example 

The following statement drops the server named testasa:

DROP SERVER testasa