DROP SERVER Statement

Drops a remote server from the Sybase IQ system tables.

Syntax

DROP SERVER server-name

Examples

Usage

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

Side Effects
  • Automatic commit

Standards

  • SQL—ISO/ANSI SQL compliant.

  • Sybase—Supported by Open Client/Open Server.

Permissions

Only the DBA account can delete a remote server.

Related reference
CREATE SERVER Statement