Previous Topic: Forward and Reverse Engineering Validation RulesNext Topic: Filter Tables in the Schema Generation Dialog for Forward Engineering


Column and Table Level Validation Table

The following table lists each forward engineering option that you can select to include column and table-level validation rules in the generated schema:

SQL DBMS

Column-Level Validation

Table-Level Validation

DB2 iSeries

Not supported

Not supported

Informix

Column CHECK

Table CHECK

DB2 z/OS

FIELDPROC/Check

Table Check

DB2 UDB

Column CHECK

Table CHECK

Oracle

CHECK Constr

Table CHECK

Progress [4GL]

Validation

Table Validation

Progress [ODBC SQL]

Not supported

Not supported

SQL Server

Validation

Table CHECK

SAP ASE

Validation

Table CHECK

Teradata

BETWEEN

Not supported

Note: A validation rule statement cannot be generated in the schema if the target database does not support the required validation syntax. See your DBMS documentation for additional information on support and syntax for data validation rules.