Previous Topic: Validation RulesNext Topic: Add a Validation Rule


How 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:

DBMS

Independent Statement Option

CHECK Option

DB2 z/OS

FIELDPROC

CHECK Constraint

SQL Server

sp_bindrule

CHECK Constraint

SAP ASE

sp_bindrule

CHECK Constraint

More information:

Validation Rules