Modifying Schema Entities › Modifications to an Unloaded Database › Deleting a Schema

Deleting a Schema

What Components are Affected

When you delete a schema, the definitions of the schema and all subschemas associated with the schema are removed from the dictionary.

Steps to delete a schema

To delete a schema from the dictionary:

1. Delete the schema
2. Delete load modules associated with the deleted subschemas
3. Delete files that contain the data
4. Delete the segment(s) corresponding to the schema
5. Regenerate all affected DMCLs
6. Remove the segment(s) from the database name table
7. Delete SQL schema(s) referencing the non-SQL schema

Considerations

When you delete a schema, subschemas associated with that schema are also deleted. The subschema load modules are not deleted.

In addition, the physical database definition(s) that apply to the schema's areas are not automatically deleted. You must modify the physical database definitions to delete the areas and regenerate all affected DMCLs.