beautypg.com

Views tab, Procedures tab, Synonyms tab – HP Neoview Release 2.5 Software User Manual

Page 65: Ddl tab, Views tab procedures tab synonyms tab ddl tab

background image

Name: Name of the materialized view group. Each materialized view group is
hyperlinked and detailed information about the materialized view group is displayed.

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

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

Views Tab

To display the views that belong to the schema:

1.

Select a Schema in the navigation tree.

2.

Click the Views tab in the right pane, or open the Views folder.

In the right pane, these attributes are displayed:

Name: Name of the view. Each view is hyperlinked and detailed information about the
view is displayed.

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

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

Procedures Tab

To display the procedures that belong to the schema:

1.

Select a Schema in the navigation tree.

2.

Click the Procedures tab in the right pane, or open the Procedures folder.

In the right pane, these attributes are displayed:

Name: Name of the procedure. Each procedure name is hyperlinked and detailed
information about the procedure is displayed.

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

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

Synonyms Tab

To display the synonyms that belong to the schema:

1.

Select a Schema in the navigation tree.

2.

Click the Synonyms tab in the right pane, or open the Synonyms folder.

In the right pane, these attributes are displayed:

Name: Name of the synonym. Each synonym name is hyperlinked and detailed
information about the synonym is displayed.

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).

DDL Tab

To display the DDL output for the schema:

Display Schemas and Their Objects

65