Variables for Reference Columns

%CKEYCOLUMN%

Generated code of Parent table column (primary key)

%FKEYCOLUMN%

Generated code of Child table column (foreign key)

%PK%

Generated code of Primary key column

%PKNAME%

Primary key column name

%FK%

Generated code of Foreign key column

%FKNAME%

Foreign key column name

%AK%

Alternate key column code (same as PK)

%AKNAME%

Alternate key column name (same as PKNAME)

%COLTYPE%

Primary key column data type

%DEFAULT%

Foreign key column default value

%HOSTCOLTYPE%

Primary key column data type used in procedure declaration. For example: without length