Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Accessing remote data » Working with remote servers

 

Delete 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. Use the SQL Anywhere 12 plug-in to 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 click 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