Displaying 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 HPE NonStop SQL/MX Release 3.4 Reference Manual. To display the store order properties:

Procedure

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