Displaying table primary key properties

To display the table primary key properties:

Procedure

  1. Select a table in the left pane.
  2. 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 or Descending.

    • Added By—This property indicates whether the column was added by the system or by user.