Database Changes

Table Added

Adding tables to the database has no effect on an Access Definition or any process request.

Table Deleted

If a table referenced in an Access Definition is dropped from the database, the status for that table in the Access Definition Editor is Unknown and a warning message is displayed.

Although you can use an Access Definition with a table in Unknown status, it is prudent to verify that the Access Definition describes the appropriate data. If the Start Table is dropped, you must select a different Start Table.

Column Added

If a column is added to a database table, the new column is included in the Access Definition automatically.

Column Modified

Changes to column attributes (data length or data type) in a database table affect an Access Definition. You can use the Access Definition; however, if you use it in a process, a warning is displayed.

Column Deleted

If a column in a database table that is referenced in an Access Definition is deleted, the effects vary:

• If the column is referenced explicitly (included in the selection criteria, a relationship, or the primary key), an error message is displayed. You must remove any explicit references to the deleted column before you can use the Access Definition.
• If the column is not referenced explicitly, a warning message is displayed, but you can use the Access Definition in a process. Verify that the Access Definition describes the appropriate data.

Relationship Added

New relationships are included in the Access Definition automatically and are assigned New status. By default, an Access Definition uses all new relationships, unless you specify otherwise.

Relationship Modified

Modified relationships are assigned New status in the Access Definition. An Access Definition uses all new relationships, unless you specify otherwise.

Relationship Deleted

Deleted relationships are assigned Unknown status in the Access Definition and a warning message indicates that the relationship is not found.