Physical Modeling › Validation Rules › How CA ERwin Data Modeler Generates Validation Rules

How CA ERwin Data Modeler Generates Validation Rules

You can implement validation rules as independent validation statements or as CHECK constraint clauses in the appropriate CREATE TABLE statements in the generated schema. During forward engineering, each validation rule for which you select the independent statement option (FIELDPROC, INTEGRITY, sp_bindrule) is generated in the schema as an independent statement. All other validation rules are implemented as a CHECK clause included in the CREATE TABLE or ALTER TABLE statement.

The following table shows the options for each target server that supports this feature:

More information:

Validation Rules