vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_06_0206.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

4.7 KiB
Raw Permalink Blame History

DROP SERVER

Function

DROP SERVER deletes an existing data server.

Precautions

Only the server owner can delete a server.

Syntax

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

Parameter Description

  • IF EXISTS

    Sends a notice instead of an error if the specified table does not exist.

  • server_name

    Specifies the name of a server.

  • CASCADE | RESTRICT
    • CASCADE: automatically drops objects that depend on the server to be deleted.
    • RESTRICT (default): refuses to delete the server if any objects depend on it.

Examples

Delete the hdfs_server server.

1
DROP SERVER hdfs_server;

Helpful Links

CREATE SERVER, ALTER SERVER

Parent topic: DDL Syntax