Previous Topic: ConstraintsNext Topic: Attaching a System Generated Default or Initial Value to a Column

Creating Models › Creating a Physical Model › Constraints › Target Server Constraint Terminology

Target Server Constraint Terminology

The various target databases use different terminology to describe constraints as summarized in the following table.

The following table lists the Constraint terminology as it appears in the Schema Generation dialog.

DBMS

Column-Level Constraint Terminology

Column-Level Default Terminology

Table-Level Constraint Terminology

DB2 for i

N/A

DEFAULT Value

N/A

DB2 LUW

Column CHECK

DEFAULT Value

Table CHECK

DB2 z/OS

FIELDPROC/Check

DEFAULT Value

VALIDPROC/Check

Informix

Column CHECK

DEFAULT Value

Table CHECK

Oracle

Check Constraint

DEFAULT Value

Table CHECK

PostgreSQL

N/A

DEFAULT Value

Table CHECK and EXCLUDE

Progress

Validation

Initial Value

Table Validation

SAS

N/A

N/A

N/A

SQL Server

Validation

Default

Table Validation

SAP ASE

Validation

Default

Table Validation

Teradata

Column CHECK

DEFAULT Value

Table CHECK

Note: Although constraint dialogs are provided, SQL constraint statements are not generated for the target servers that do not support constraints.

More information:

Define Oracle Default Values