Deleting remote servers

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

To delete a remote server (Sybase Central)

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

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

  3. Select the remote server, and then choose File » Delete.

To delete a remote server (SQL)

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

  2. Execute a DROP SERVER statement.

For more information, see DROP SERVER statement.

Example

The following statement drops the server named RemoteSA:

DROP SERVER RemoteSA;