Support "on update" and "on delete" DDL generation
Most of the modern database support specifying on update and on delete options. This helps in reducing the amount of SQL statements needed to perform an update or delete action and also maintaining the integrity of the database. The latest VP Suite 2.3 SP3 supports generating DDL file with on update and on delete options which allows you utilize these facilities provided by the DBMS.
To specify "on update" and "on delete" action
Open the specification dialog of the relationship
Select “On Delete” and “On Update” at the bottom part of the specification dialog and choose the appropriate action in the combo box
and you will see the options being generated to the DDL file
Resources
