11.9.2 Deleting a schema
To delete a schema, you execute the DROP SCHEMA statement.
For details about the DROP SCHEMA statement, see DROP SCHEMA (delete a schema) under Definition SQL in the manual HADB SQL Reference.
- Important
-
If you delete a schema, all schema objects defined in the schema are also deleted.
If a base table is defined in a schema to be deleted, beforehand, see the explanation in 11.1.15 Deleting base tables. If you delete a schema in which a non-updatable base table is defined, temporary work files created by the interrupted command might remain.