Properties of RI Constraints

The following list details the RI constraint properties that can be changed:

RI Constraint Generic Name—The generic name of the RI constraint is a name that is consistent for the implemented relationship throughout all of the technical designs. It is called generic because it is not DBMS specific.
The generic name can be no more than 32 characters long.

There is no reason to change this name in the Data Structure List.
RI Constraint DBMS Name—If the DBMS detects a referential integrity error, this RI constraint name appears in the error message. Therefore, you should name the RI constraint something meaningful.
Referential Integrity Options Enforced by—You have the option on each RI constraint to have the DBMS handle the constraint (if the DBMS contains the capability to handle the particular constraint) or let CA Gen generate the code to handle the constraint.
Typically better performance is gained by selecting the DBMS to handle anything it can and let CA Gen generate the constraints not handled by the DBMS.
Description—A free text field used to document the purpose of this RI constraint.