Synonym Checks (PDM)

PowerDesigner provides default model checks to verify the validity of synonyms.

Check

Description and Correction

Synonym name and code uniqueness

Synonym names and codes must be unique in the model.

Manual correction: Modify the duplicate name/code

Automatic correction: Appends a number to the duplicate name/code

Synonym name and code maximum length

The synonym name and code length is limited by the maximum length specified in the DBMS definition (MaxLen entry, in the Objects > Synonym category) and in the naming conventions of the model options.

Manual correction: Modify the name/code length to meet this requirement

Automatic correction: Truncates the name/code length to the maximum length specified in the DBMS definition

Existence of the base object

A synonym must correspond to a model object. By default, when you create synonyms from the List of Synonyms using the Add a Row tool, they are not attached to any base object.

Manual correction: Select a base object from the synonym property sheet

Automatic correction: Deletes the synonym