DROP SERVER

Description

Deletes an existing data server.

Precautions

Only the server owner or a user granted with the DROP permission can run the DROP SERVER command. The system administrator has this permission by default.

Syntax

DROP SERVER [ IF EXISTS ] server_name [ { CASCADE | RESTRICT } ] ;

Parameter Description

• IF EXISTS

  Reports a notice instead of an error if the specified data server does not exist.

• server_name

  Specifies the name of the data server to be deleted.

• CASCADE | RESTRICT
  • CASCADE: automatically deletes the objects that depend on the data server.
  • RESTRICT: refuses to delete the server if any objects depend on it. This is the default action.

Examples

See Examples in section "CREATE SERVER."

Helpful Links

ALTER SERVER and CREATE SERVER