DROP SCHEMA

Updated on 2024-05-21 GMT+08:00

View PDF

Deletes a schema from the current database.

Only the schema owner or a user granted with the DROP permission can run the DROP SCHEMA command. The system administrator has this permission by default.
Only initial users and O&M administrators can run the DROP SCHEMA command for O&M administrators. Other users cannot run DROP SCHEMA for O&M administrators.

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

IF EXISTS
Reports a notice instead of an error if the specified schema does not exist.
schema_name
Specifies the name of the schema to be deleted.

Value range: an existing schema name
CASCADE | RESTRICT
- CASCADE: automatically deletes all the objects contained in the schema.
- RESTRICT: refuses to delete the schema if the schema contains objects. This is the default action.

NOTICE:

Schemas beginning with pg_temp or pg_toast_temp are for internal use. Do not delete them. Otherwise, unexpected consequences may be incurred.

NOTE:

The schema currently being used cannot be deleted. To delete it, switch to another schema first.

See Examples in section "CREATE SCHEMA."

Parent topic: SQL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.