Displaying table primary key properties
To display the table primary key properties:
Procedure
- Select a table in the left pane.
-
In the right pane, click
Primary Key.
The following details appear:
-
Constraint Name—The name of the constraint when the table is created. For more information, see HPE NonStop SQL/MX Release 3.4 Reference Manual .
-
Metadata UID—The internal UID number for the constraint.
-
Droppable—This property indicates whether this constraint can be dropped, by specifying it while creating the table.
-
Position—The position of the column in the table.
-
Column Name—The name of the column (string).
-
Data Type—The SQL data type of the column.
-
Sort Order—The order specified as
Ascending
orDescending
. -
Added By—This property indicates whether the column was added by the system or by user.
-