Previous Topic: Forward and Reverse-Engineering IndexesNext Topic: Column and Table Level Validation Table


Forward and Reverse Engineering Validation Rules

When you generate the physical database schema from a physical model, you can include table-level or column-level validation rules. The validation rule definitions are translated into schema statements and the specified parameters are inserted in the correct syntax.

When reverse-engineering from a schema file, script, or system catalog, validation rules are imported and attached to the appropriate table or column in the resulting model. The convention that is used to name the imported validation rules is as follows:

VALID_RULEn

Here n is a sequential number starting at zero. The first validation rule that is encountered is named VALID_RULE0, the next rule VALID_RULE1, and so forth, until the entire schema is processed.

The Column and Table Level Validation Table lists each option that you can select in the schema generation for column and table-level validation rules.

More information:

Validation Rules