1DROP SERVER(7)                   SQL Commands                   DROP SERVER(7)
2
3
4

NAME

6       DROP SERVER - remove a foreign server descriptor
7
8

SYNOPSIS

10       DROP SERVER [ IF EXISTS ] servername [ CASCADE | RESTRICT ]
11
12

DESCRIPTION

14       DROP  SERVER  removes an existing foreign server descriptor. To execute
15       this command, the current user must be the owner of the server.
16

PARAMETERS

18       IF EXISTS
19              Do not throw an error if the server does not exist. A notice  is
20              issued in this case.
21
22       servername
23              The name of an existing server.
24
25       CASCADE
26              Automatically  drop  objects  that depend on the server (such as
27              user mappings).
28
29       RESTRICT
30              Refuse to drop the server if any objects depend on it.  This  is
31              the default.
32

EXAMPLES

34       Drop a server foo if it exists:
35
36       DROP SERVER IF EXISTS foo;
37
38

COMPATIBILITY

40       DROP  SERVER conforms to ISO/IEC 9075-9 (SQL/MED). The IF EXISTS clause
41       is a PostgreSQL extension.
42

SEE ALSO

44       CREATE SERVER [create_server(7)], ALTER SERVER [alter_server(7)]
45
46
47
48SQL - Language Statements         2011-09-22                    DROP SERVER(7)