Constraint Field Macros

This table lists the macros that are available in DDL templates to access constraint-related fields, where (in Enterprise Architect) the fields are editable, such as 'Constraint Name' and 'Constraint Type'.

ddlConstraintAlias

'Columns and Constraints' dialog: 'Constraints' tab: Alias cell.

ddlConstraintColumnAlias

'Columns and Constraints' dialog: 'Constraints' tab: Involved Columns: Assigned list.

ddlConstraintColumnName

'Columns and Constraints' dialog: 'Constraints' tab: Involved Columns: Assigned list.

ddlConstraintComment

'Columns and Constraints' dialog: 'Constraints' tab: Notes text field.

ddlConstraintName

'Columns and Constraints' dialog: 'Constraints' tab: Name cell.

ddlPKColumnCount

Only relevant if the current constraint has a type of Primary Key, this macro will return a count of assigned columns to the Primary Key.

'Columns and Constraints' dialog: 'Constraints' tab: Involved Columns: Assigned list.

ddlReferenceColumnAlias

Only relevant if the current constraint has a type of Foreign Key, this macro will return the column alias from the reference table.

'Columns and Constraints' dialog: 'Constraints' tab: Alias cell.

ddlReferenceColumnName

Only relevant if the current constraint has a type of Foreign Key, this macro will return the column name from the reference table.

Foreign Key Constraint dialog: Involved Columns list: Parent column.

ddlReferenceTableAlias

Only relevant if the current constraint has a type of Foreign Key, this macro will return the reference table's alias.

'Table Properties' dialog: 'Main' tab: Alias text field.

ddlReferenceTableName

Only relevant if the current constraint has a type of Foreign Key, this macro will return the reference table's name.

Foreign Key Constraint dialog: Involved Columns list: Parent column header.

ddlReferenceTableOwner

Only relevant if the current constraint has a type of Foreign Key, this macro will return the reference table's owner.

Foreign Key Constraint dialog: Involved Columns list: Parent column header.

ddlSchemaConstraintColumnName

The column names involved in the current constraint read in from the live database.

Note: this field is not editable directly in Enterprise Architect.

ddlSchemaConstraintName

The Constraint Name property read in from the live database.

Note: this field is not editable directly in Enterprise Architect.

ddlSchemaConstraintType

The Constraint Type property read in from the live database.

Note: this field is not editable directly in Enterprise Architect.