Update CDD Schema Table

If a table in the IFAS database schema is updated to add/remove/modify the columns, it is recommended that the CDD schema for the same table be updated as well in case a new CDD report is created from it.

Any existing CDD report will not be impacted unless some columns are removed or modified from the table. In that case, the report should be verified to see if those columns were used in the report.

Update the CDD schema:

1. Open CDD report designer.

2. From the CDD designer menu options, select Tools and then select Catalog Manager. A new window will open.

3. Select Catalog Tables, expand the catalog items, and navigate to the desired table name (if it was added to CDD schema).

   1. If present, select the table to remove. Select Yes on the alert message.

4. Close this window, and then re-open it.

5. From the list of database items, navigate to the table name in question and then select Import. This table will be added to the CDD schema and should show up in the list of its items.

6. Close the window.

7. Repeat if other tables need to be updated in the CDD schema.