beautypg.com

Displaying synonyms and their properties, Attributes tab – HP Neoview Release 2.4 Software User Manual

Page 49

background image

Displaying Synonyms and Their Properties

To display the synonym names in the schema:

1.

Start the HP Database Manager and log on using any user ID.

2.

Click the Database area.

3.

Select a system in My Active Systems in the navigation tree.

4.

Select a Schema in the navigation tree.

5.

Click on the Synonyms tab in the right pane and select a synonym name, or open the
Synonyms folder and select a synonym name in the tree.

In the right pane, these tabs appear:

Attributes tab

Usage tab

DDL tab

Attributes Tab

To display the synonym names and attributes:

1.

Select a Schema in the navigation tree.

2.

Click on the Synonyms tab in the right pane and select a synonym name, or open the
Synonyms folder and select a synonym name in the tree.

3.

Click on the Attributes tab in the right pane.

In the right pane, these attributes are displayed:

Name: Name of the synonym.

Creation Time: Time and date when the synonym was created. Timestamp is in the
format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).

Redefinition Time: Time and date when the synonym was last redefined. Timestamp
is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).

Displaying Synonyms and Their Properties

49