Configuration Guide

Back Next

Maintenance of Queries and Packages

If you change the database schema after you create queries and packages, the

MDM Hub

updates queries and packages. The update depends on the type of schema change. You might need to edit some queries and packages manually.

The following table lists the types of schema changes, describes the actions taken by the

MDM Hub

, and notes any actions that you need to perform:

Schema Change	Generic Queries and Packages	Custom Queries and Packages
Revised column name	Updates the generic queries and packages to use the revised column name.	Updates the custom queries and packages to use the revised column name.
Deleted column	Removes the deleted column from the generic queries and packages.	Custom queries are not updated. The custom queries and packages that use the deleted column are no longer valid. You must edit the queries and packages to remove the deleted column.
Deleted base object	Deletes the generic queries and packages that use the deleted base object.	Custom queries are not updated. The custom queries and packages that use the deleted base object are no longer valid. You must delete the queries and the dependent packages.