beautypg.com

Dropping a table – HP NonStop G-Series User Manual

Page 139

background image

Managing Tables

12-14

Change Security

Use the Security pane to change the security or owner and group Ids of the
table.

Figure 12-10. Security Pane.

To change the security of the table, use the drop-down lists in the R,W, E
and P fields.

Change the owner ID by typing a new group ID in the first Owner ID field,
and a new user ID in the second field.

Add Columns

To add columns, click on Columns Tab of the Alter Table window. The
Columns window is displayed. Refer to Add Columns for instructions on
adding columns to a table.

Dropping a Table

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

To display the Drop Table window, click on Tables in the Main window,
then click on Drop. The Drop Table window is displayed, as shown in
Figure 12-11.