vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_06_0204.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

5.5 KiB
Raw Permalink Blame History

DROP SCHEMA

Function

DROP SCHEMA deletes a schema in a database.

Precautions

  • Only the owner of a schema or a user granted with the DROP permission for the schema or a system administrator has the permission to execute the Drop SCHEMA statement.
  • Do not delete the schemas with the beginning of pg_temp or pg_toast_temp. They are internal system schemas, and deleting them may cause unexpected errors.
  • A user cannot delete the schema in use. To delete the schema in use, switch to another schema.

Syntax

1
DROP SCHEMA [ IF EXISTS ] schema_name [, ...] [ CASCADE | RESTRICT ];

Parameter Description

  • IF EXISTS

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

  • schema_name

    Specifies the name of a schema.

    Value range: An existing schema name.

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes all objects that are contained in the schema to be deleted.
    • RESTRICT: refuses to delete the schema that contains any objects. This is the default.

Example

Delete the ds_new schema:

1
DROP SCHEMA ds_new;

Links

ALTER SCHEMA, CREATE SCHEMA

Parent topic: DDL Syntax