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

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

DROP SERVER statement

Drops a remote server from the catalog.

  • Drop a remote server
    DROP [ REMOTE ] SERVER server-name
  • Drop a remote server (SAP HANA syntax)
    DROP REMOTE SOURCE remote-source-name

The DROP SERVER, DROP REMOTE SERVER, and DROP REMOTE SOURCE statements are semantically equivalent. The DROP REMOTE SOURCE syntax is provided for compatibility with SAP HANA.


You must drop all the proxy tables that have been defined for the remote server before this statement succeeds.


You must have the SERVER OPERATOR system privilege.

Side effects

Automatic commit.

  • ANSI/ISO SQL Standard

    Not in the standard.


The following example drops a fictitious server named ase_prod:

DROP SERVER ase_prod;