Variables for Columns

Parent Table variables are also available.

Variable

Comment

%COLUMN%

Generated code of Column

%COLNNO%

Position of Column in List of columns of Table

%COLNNAME%

Name of Column

%COLNCODE%

Code of Column

%PRIMARY%

Contains Keyword "primary" if Column is primary key column

%ISPKEY%

TRUE if Column is part of Primary key

%FOREIGN%

TRUE if Column is part of one foreign key

%COMPUTE%

Compute constraint text

%NULLNOTNULL%

Mandatory status of a column. This variable is always used with NullRequired item, see Working with Null values