DROP SERVER statement

Description

Drops a remote server from the IQ system tables.

Syntax

DROP SERVER server-name

Examples

Example 1

DROP SERVER ase_prod

Usage

DROP SERVER deletes a remote server from the IQ system tables. You must drop all the proxy tables that have been defined for the remote server before this statement will succeed.


Side effects

Automatic commit.

Standards

Permissions

Only the DBA account can delete a remote server.

See also

CREATE SERVER statement