DROP SERVER statement

Drops a remote server from the catalog.

Syntax

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

Parameters

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.

Remarks

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

Privileges

You must have the SERVER OPERATOR system privilege.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

The following example drops a fictitious server named ase_prod:

DROP SERVER ase_prod;