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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Remote data access » Remote servers


Dropping remote servers (SQL)

Administrators can drop remote servers using the DROP SERVER statement.


You must have the SERVER OPERATOR system privilege.

Context and remarks

All proxy tables defined for the remote server must be dropped before dropping the remote server. The following query can be used to determine which proxy tables are defined for the remote server server-name.

SELECT st.table_name, sp.remote_location, sp.existing_obj
    FROM sysproxytab sp
    JOIN sysserver ss ON ss.srvid = sp.srvid
    JOIN systab st ON sp.table_object_id = st.object_id
    WHERE ss.srvname = 'server-name';
 Drop a remote server
  1. Connect to the host database.

  2. Execute a DROP SERVER statement.

    DROP SERVER server-name;


The remote server is dropped.


The following statement drops the remote server named RemoteASE.


 See also