|
|
|
In certain situations, SQL/DDL scripts are generated to correct detected problems. For instance, the following example shows that the Foreign Key FK_REGION_COUNTRY should be dropped, and a new FK in table REGION referencing table STATE should be created. All you need to do is click the Correction button. Then the script for corrective action is generated.
The following diagram shows an example:
In the next example, the scripts are generated to implement the Foreign Keys and the implied relationships so that the database system will be able to enforce these references:
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |