Previous Topic: Where to Use User-Defined Property MacrosNext Topic: Creating a Physical Model

Creating Models › Creating a Logical Model › User-Defined Properties › User-Defined Property Macro Table

User-Defined Property Macro Table

The following table lists each object class that supports a macro, and the corresponding macro:

Object Class

Corresponding Macro

Entity

%EntityProp(UDPName)

Table

%TableProp(UDPName)

Attribute

%AttProp(UDPName)

Column

%ColProp(UDPName)

Key Group

%KeyGroupProp(UDPName)

Index

%IndexProp(UDPName)

Logical Relationship

%RelLogProp(UDPName)

Physical Relationship

%RelPhysProp(UDPName)

Subject Area

%SubjectAreaProp(UDPName)

Model

%DiagramProp(UDPName)

The UDPName macro argument is the UDP name that you define in the User Defined Properties editor. For example, to define the department, you can add an entity UDP called Department and assign "Accounting" as a UDP property value associated with an entity. You could then use the %EntityProp(Department) macro to display the UDP Department value (Accounting) in the model. Macros can make models more descriptive according to your requirements.