Columns tab, Attributes tab, Columns tab attributes tab – HP Neoview Release 2.4 Software User Manual

Page 56

Advertising
background image

In the right pane, these tabs appear:

Columns tab

Attributes tab

DDL tab

Partitions tab

Columns Tab

To display the table index columns:

1.

Select a Schema in the navigation tree.

2.

Click the Tables folder and open the Indexes folder and select an index name.

3.

Click the Columns tab in the right pane.

In the right pane, these attributes are displayed:

Column Name: Name of the column (string).

Sort Order: Specifies the order as “Ascending” or “Descending.”

Added By: Indicates if column was added by the “System” or “User.”

Attributes Tab

To display the table index attributes:

1.

Select a Schema in the navigation tree.

2.

Click the Tables folder and open the Indexes folder and select an index name.

3.

Click the Attributes tab in the right pane.

In the right pane, these attributes are displayed:

Name: Name of the index.

Unique: Specifies if the index is unique, the value is “Yes” or “No.”

56

Manage Database Objects

Advertising