Prev | Next |
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.