Previous Topic: Enter Materialized View Column User-Defined Property ValuesNext Topic: Target Server Constraint Terminology


Constraints

You can enter constraint information in the form of default or initial values and validation rules in both the logical and physical model. You can define and attach validation rules, default values, or initial values to tables, columns, entities, and attributes.

Validation rules and default table and column values are generated with the appropriate data definition statements for your target DBMS, either actively through connection to the system catalog or to a DDL script.

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

More information:

Add a Default or Initial Value for a Target Server

Default Value Editor

Attaching a System Generated Default or Initial Value to a Column