Annotating a model element

Tagged values on a model element

The tagged values used to annotate model elements are presented in the following table:

The ... tagged value	Role	SQL
{sqlName(SQL_Name)}	Indicates the model element's SQL name.

The {sqlName} tagged value

The {sqlName} tagged value is used as follows:

· for a class, it indicates the name of the table, the view

· for an attribute, it indicates the name of the table column

· for an association end, it is the prefix for double foreign key attributes and for foreign key constraint names

· for an association, it indicates the name of the external table

· for an operation, it indicates the SQL name of the trigger or of the stored procedure

· for a datatype, it indicates the SQL name of the type or the definition of the type if no "sqlCode" note is present on the datatype

· for a package, it indicates the name of the schema, the database or the physical model

Note: An element annotated {sqlName} must have a name composed of more than one character.