Please note : This help page is for an older version of Enteprise Archtiect. The latest help can be found here.

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.