You can execute the DROP SCHEMA statement to delete a schema from a database. This topic describes how to use the DROP SCHEMA statement and the limits on using the statement.
You cannot delete the public schema, which is automatically created by Hologres for each database.
The following table describes the parameters in the statement.
DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
|CASCADE||The keyword indicating that the system automatically deletes all objects such as tables, functions, and data in the target schema.|
|RESTRICT||The keyword indicating that the system does not delete a schema if the schema contains any objects.|
DROP SCHEMA mystuff CASCADE;