Working with Data Models › Macro Toolbox › Entity Macros › %KeyType

%KeyType

Used within the scope of %ForEachKey or %ForEachIndex to return the key's IDEF1X type.

• FK (IFn where n is a number starting with a unique model number)
• PK (unique)
• AKn (where n is a number starting at one for each table)
• IEn (where n is a number starting at one for each table)

Syntax

%KeyType

Syntax Example

%ForEachTable {%EntityName

%ForEachKey {

%KeyName %KeyType

}

}

Expansion

IE1

Usage

Classified as an Entity macro that you can use in the Table Trigger Editor (Triggers dialog).