Synonyms

The Synonyms option screen displays when you select option 5 from the Object Selection menu. It lets you specify whether you want to modify, create, or drop a synonym.

Synonyms Option Screen

OPTION

Specify the letter representing the activity you want to perform.

C	Create a synonym.
D	Drop a synonym.
M	Model a synonym and create a new synonym.

Specify Synonym Information: (* or pattern for list) Area

Synonym Name

Name of the synonym you want to create, drop, or model. This field is required. You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.

Effective SQLID

SQLID for the synonym name. This may be the same as the user ID. This field is required. You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.

Specify CREATE Synonym Options: (* or pattern for list) Area

Table Creator

ID of the user who created the table on which the synonym is based. This field is required if you are creating a synonym. If this information is in your user profile (see Defaults-and-user-parameters-function for details), the field is prefilled.

You can also specify a generic name with * (asterisk), or a pattern. This displays a selection window, from which you can select a specific object.

Table Name

Name of the table on which the synonym is based. If you have just finished creating the table, the field is prefilled. This field is required if you are creating a synonym. Not used if you are modeling an synonym.