Variables for Domains and Column Checks

%UNIT%

Unit attribute of standard check

%FORMAT%

Format attribute of standard check

%DATATYPE%

Data type. Ex: int, char(10) or numeric(8, 2)

%DTTPCODE%

Data type code. Ex: int, char or numeric

%LENGTH%

Data type length. Ex: 0, 10 or 8

%PREC%

Data type precision. Ex: 0, 0 or 2

%ISRDONLY%

TRUE if Read-only attribute of standard check has been selected

%DEFAULT%

Default value

%MINVAL%

Minimum value

%MAXVAL%

Maximum value

%VALUES%

List of values. Ex: (0, 1, 2, 3, 4, 5)

%LISTVAL%

SQL constraint associated with List of values. Ex: C1 in (0, 1, 2, 3, 4, 5)

%MINMAX%

SQL constraint associated with Min and max values. Ex: (C1 <= 0) AND (C1 >= 5)

%ISMAND%

TRUE if Domain or column is mandatory

%MAND%

Contains Keywords "null" or "not null" depending on Mandatory attribute

%NULL%

Contains Keyword "null" if Domain or column is not mandatory

%NOTNULL%

Contains Keyword "not null" if Domain or column is mandatory

%IDENTITY%

Keyword "identity" if Domain or Column is identity (Sybase specific)

%WITHDEFAULT%

Keyword "with default" if Domain or Column is with default

%ISUPPERVAL%

TRUE if the upper-case attribute of standard check has been selected

%ISLOWERVAL%

TRUE if the lower-case attribute of standard check has been selected