HP Integrity NonStop J-Series - Manual (Page 55)

2. In the right pane, click Columns.
The following details appear:
•
Primary Key: — An icon or special symbol to indicate that the column is part of the
primary key. If the column is not a part of the primary key, the field is blank.
•
Column Name: — The name of the column (string).
•
Data Type: — The SQL data type of the column.
•
Nullable: — If a column is NOT NULL or NOT NULLABLE NOT DROPPABLE, the value
displayed is Not Nullable Not Droppable. Otherwise, the field is blank.
•
Default: — A constant selected by default if no value was specified for this column.
•
Heading: — The string displayed at the top of the column values when a select statement
is executed on the table.
Viewing table primary key properties
To view the primary key properties:
1.
In the navigation tree, select the table.
2. In the right pane, click Primary Key.
The following details appear:
•
Constraint Name: — The name of the constraint when the table was created. For more
information, see the HP NonStop SQL/MX Release 3.2.1 Reference Manual.
•
Metadata UID: — The internal UID number for the constraint.
•
Droppable: — This property indicates whether this constraint can be dropped. You can
specify whether the constraint can be dropped while creating the table.
•
Position: — The position of the column in the primary key order.
•
Column Name: — The name of the column (string).
•
Data Type: — The SQL data type of the column.
•
Sort Order: — The order specified as Ascending or Descending.
•
Added By: — This property indicates whether the column was added by the system or
by the user.
Viewing hash key properties
To view the hash key properties:
1.
In the navigation tree, select the table.
2. In the right pane, click Hash Key.
The following details appear:
•
Key Sequence: — The position of the column in the hash key order.
•
Column Name: — The name of the column (string).
•
Sort Order: — The order specified as Ascending or Descending.
Viewing store order properties
You can specify the store order properties while creating a table. Alternatively, the store order
properties can be determined by the system. For more information, see the HP NonStop SQL/MX
Release 3.2.1 Reference Manual. To view the store order properties:
1.
In the navigation tree, select the table.
Viewing table properties 55