HP NonStop G-Series - Manual (Page 170)

NonStop dba/m Database Manager for NonStop SQL/MP User’s Guide 522632-005 13-5
The fields shown in the Base Tables and Columns pane are defined as
follows:
•
Table Name, name of the base table.
•
Alias, correlation name used in the view definition.
•
Table Column Name, name of the column in the base table.
•
Type, data type of the columns in the base table.
•
View Column Name, name of the column in the view.
•
Heading, the heading text for the column in the view.
Display Indexes on Base Tables
You display the indexes on the base table by clicking on the Show Index
button. All indexes and index columns are displayed in the Indexes View
window.
Add Columns
Use the fields in the Base Tables and Columns pane to add columns to the
view.
To add a column to the base table
1. In the Table Column Name field, double-click on the name of the
column you want to add to the view. The selected column name is
displayed in the View Column Name field. To select all columns , click
on the Select All button.
2. Place the cursor in the View Column Name field to edit the name of the
column.
3. Place the cursor in the Heading field to enter the name of the column.
4. Repeat Steps 1 through 3 to add more columns.
5. After you have selected all columns for the view and edited their names
and headings, click on Projection to create the columns list for the
view. Part of the CREATE VIEW statement appears in the View Text
pane. An example of the View Text pane is shown in Figure 13-6.
6. To clear all columns, click on the Clear All button.