Show TOC

DROP SERVER StatementLocate this document in the navigation structure

Drops a remote server from the SAP IQ system tables.

Syntax
DROP SERVER <server-name>
Examples

(back to top)

  • Example 1 this example drops the server IQ_prod:
    DROP SERVER iq_prod
Usage

(back to top)

Before DROP SERVER succeeds, you must drop all the proxy tables that have been defined for the remote server.

Side Effects
  • Automatic commit
Standards

(back to top)

  • SQL—ISO/ANSI SQL compliant.
  • SAP Database products—Supported by Open Client/Open Server.
Permissions

(back to top)

Requites the SERVER OPERATOR system privilege.