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

2. In the right pane, click Store Order.
The following details appear:
•
Position: — The position of the column in the key, for the physical file.
•
Column Name: — The name of the column (string)
•
Sort Order: — The order specified as Ascending or Descending.
•
Added By: — The property indicates whether the column was added by the system or by
the user.
Viewing check constraints
To view the check constraints for a table:
1.
In the navigation tree, select the table.
2. In the right pane, click Check Constraints.
The following details appear:
•
Constraint Name: — The name of the check constraint.
•
Metadata UID: — The internal UID number for the constraint.
•
Text: — A string that defines the constraint, as shown in the SHOW DDL output.
Viewing unique constraints
To view the unique constraints for a table:
1.
In the navigation tree, select the table.
2. In the right pane, click Unique Constraints.
The following details appear:
•
Constraint Name: — The name of the unique constraint.
•
Metadata UID: — The internal UID number for the constraint.
•
Columns: — The names of the columns that are constrained.
Viewing foreign key properties
To view the foreign key properties:
1.
In the navigation tree, select the table.
2. In the right pane, click Foreign Key.
The following details appear:
•
Name: — The name of the foreign key constraint.
•
Metadata UID: — The internal UID number of the foreign key.
•
Foreign Table: — The name of the foreign table.
•
Local Column: — The name of the local column of the foreign key.
•
Foreign Column: — The name of the foreign column of the foreign key.
•
Enforced: — The property indicates whether the referential integrity is enforced.
Viewing table attributes
To view the table attributes:
1.
In the navigation tree, select the table.
56 Viewing database objects