Modifying Schema Entities › Modifications to an Unloaded Database

Modifications to an Unloaded Database

What components are affected

Changes to a schema or schema entity in an unloaded database affects:

• The schema
• The subschemas that reference the schema
• The access modules that reference the schema
• SQL views that reference the schema

Steps

1. Modify the schema and any schema entities, as desired
2. Validate the schema
3. Regenerate any affected subschemas
4. Drop and recreate SQL views that reference the schema, as necessary
5. Alter affected access modules using the REPLACE ALL option

Schema Modifications

This section describes how to:

• Delete a schema
• Change schema characteristics