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)

Connect to the host database as a user with DBA authority.
In the left pane, double-click Remote Servers.
Select the remote server, and then choose File » Delete.

To delete a remote server (SQL)

Connect to the host database as a user with DBA authority.
Execute a DROP SERVER statement.

For more information, see DROP SERVER statement.

Example

The following statement drops the server named RemoteSA:

DROP SERVER RemoteSA;

Send feedback about this page via email or DocCommentXchange