Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Accessing Remote Data » Working with remote servers

Creating remote servers using Sybase Central Next Page

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.

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. Select the remote server you want to delete, and then choose File > Delete.

To delete a remote server (SQL)

  1. Connect to the host database from Interactive SQL.

  2. Execute a DROP SERVER statement.

    3. For more information, see DROP SERVER statement.

    Example

    The following statement drops the server named RemoteSA:

    DROP SERVER RemoteSA;