DROP SERVER
DROP SERVER
Section: SQL Commands (7) Updated: 2011-03-15 Local index
Up
NAME
DROP SERVER - remove a foreign server descriptor
SYNOPSIS
DROP SERVER [ IF EXISTS ] servername [ CASCADE | RESTRICT ]
DESCRIPTION
DROP SERVER removes an existing foreign server
descriptor. To execute this command, the current user must be the
owner of the server.
PARAMETERS
- IF EXISTS
-
Do not throw an error if the server does not exist. A notice is
issued in this case.
- servername
-
The name of an existing server.
- CASCADE
-
Automatically drop objects that depend on the server (such as
user mappings).
- RESTRICT
-
Refuse to drop the server if any objects depend on it. This is
the default.
EXAMPLES
Drop a server foo if it exists:
DROP SERVER IF EXISTS foo;
COMPATIBILITY
DROP SERVER conforms to ISO/IEC 9075-9
(SQL/MED). The IF EXISTS clause is
a PostgreSQL extension.
SEE ALSO
CREATE SERVER [create_server(7)], ALTER SERVER [alter_server(7)]
Index
- NAME
-
- SYNOPSIS
-
- DESCRIPTION
-
- PARAMETERS
-
- EXAMPLES
-
- COMPATIBILITY
-
- SEE ALSO
-
This document was created by
man2html,
using the manual pages.
Time: 22:00:56 GMT, April 16, 2011