beautypg.com

5 manage database objects, Display schemas and their objects – HP Neoview Release 2.4 Software User Manual

Page 47

background image

5 Manage 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 Active Systems in the navigation tree.

4.

Navigate to a Schema folder and click the name of the schema to see information about the
schema and its objects.

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

DDL tab

Privileges tab

Display Schemas and Their Objects

47