beautypg.com

Managing index comments – HP Integrity NonStop H-Series User Manual

Page 213

background image

dba/m Database Manager V7.1 User's Guide – 540156-001

14-11

Choose an Index

Use the Catalogs and Indexes pane to choose an index to rename.

To choose an index

1.

In the Catalogs field, double-click on the name of the catalog that
contains the index. The indexes in the selected catalog are displayed in
the Indexes field.

2.

Double-click on the index you want to rename. The attributes of the
selected index are displayed.

Display Dependencies

Before renaming an index, you can analyze the impact of renaming:

To display the programs that depend on the index, click on
Dependent Programs. Programs that would be invalidated by
renaming the index are displayed.

To display all objects, including programs, that depend on the
index, click on Objects. All SQL objects that depend on the index
are displayed.

Assign the New Name

Use the Rename pane to change the index name. To rename the index, type
the new name in the Rename field.

Managing Index Comments

You can add, modify, or delete comments for an index. Index comments
consist of one or more lines of text.

To display the Index Comment window, click on Indexes in the Main
window, then click on Index Comments. The Index Comments window is
displayed, as shown in Figure 14-5.

This manual is related to the following products: