beautypg.com

6 display database objects, Display schemas and their objects – HP Neoview Release 2.5 Software User Manual

Page 63

background image

6 Display Database Objects

This section describes how to display schemas, tables, table indexes, views, materialized views,
materialized view indexes, materialized view groups, procedures, synonyms, and triggers in
HPDM.

Display Schemas and Their Objects

To display the schema names and attributes for the schema:

1.

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

2.

Click the Database area. HPDM displays a list of existing schemas and their owners.

3.

Select a system in My Systems in the navigation tree.

4.

In the navigation tree pane, expand the All Schemas folder, and select a schema.

In the right pane, these tabs are displayed:

Attributes tab

Tables tab

Materialized Views tab

Materialized View Groups tab

Views tab

Procedures tab

Synonyms tab

Display Schemas and Their Objects

63