beautypg.com

Dropping a view – HP Integrity NonStop H-Series User Manual

Page 184

background image

Managing Indexes

13-10

2.

For a shorthand view, change the group ID in the first Owner ID field,
and the user ID in the second Owner ID field.

Figure 13-10. Security Pane.

Change Similarity Check

You can choose Similarity Check by clicking in the Similarity Check field
in the View pane.

Save the View

After you have altered a view, click on one of the following:

Execute. Executes the command immediately.

Show. Displays the SQL commands created by dba/m Database
Manager.

Queue. Queues the command to be submitted in a batch later.

Dropping a View

Use the Drop View window to delete the definition of a view. Before
dropping a view, you can analyze the impact of dropping the view by
displaying all of the objects that depend on the view.

To display the Drop View window, click on Views in the Main window,
then click on Drop. The Drop View window is displayed, as shown in
Figure 13-11.

This manual is related to the following products: