Synonym Properties

You can modify an object's properties from its property sheet. To open a synonym property sheet, double-click its Browser entry in the Synonyms folder.

The General tab contains the following properties:

Property

Description

Name

Name of the synonym (usually corresponding to a simplified name of the base object)

Code

Code of the synonym

Comment

Additional information about the synonym

Stereotype

Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined

Owner

Name of the synonym owner. You choose an owner from a list of users. A synonym can only have one owner at a time

Base Object

Name of the object origin of the synonym. The Ellipsis button displays a selection dialog box that lets you select objects among all the models opened in the current workspace and belonging to the same DBMS family as the current DBMS

Visibility

Allows to define a synonym as public (accessible to all database users) or private (available to a specific user)

Type

For those DBMS that support it (for example DB2) you can create an alias instead of a synonym. In PowerDesigner synonyms and aliases are managed in the same way whereas their behavior in the database may be different

For more information on aliases, see the DB2 documentation.