Show TOC

Specifying Advanced ConstraintsLocate this document in the navigation structure

The Additional Checks tab is initialized with PowerDesigner variables to generate the data profiling constraints specified on the Standard Checks tab and the validation rules specified on the Rules tab. You can edit the code on this tab by entering an appropriate SQL expression to supplement, modify, or replace these constraints.

Context

For columns, you can override the default Constraint name. To revert to the default name, click to reset the User-Defined button to the right of the field:

Constraint Name
The following variables are inserted by default:

  • %MINMAX% - Minimum and maximum values specified on the Standard Checks tab

  • %LISTVAL% - List of values specified on the Standard Checks tab

  • %CASE% - Character case specified on the Standard Checks tab

  • %RULES% - Constraint and validation rules specified on the Rules tab