Modifying schemas
Modifying a schema comprises several tasks for ensuring your changes
are validated, saved, and applied to user databases.
About this task
To modify a schema and put the modifications into effect or to create a new schema:
Procedure
- Start the Designer.
- Create a test database and associate it with the schema that you want to customize.
- Check out the schema that you want to customize, or create a new schema.
- Select the scripting language to use the for hook code.
- Modify the schema, either by using the Designer to change elements of the schema, or by applying packages.
- Validate the customized schema using the Validate schema command in the Designer.
- Set the test database for the schema (that is, designate that the test database that you created earlier be used to test the schema that you checked out).
- Use the test database to test the customized schema.
- Save work in progress.
- Check in the customized schema.
- Upgrade the user database with the modified schema.