AX2658

Ordering columns in a table

Column order affects the following functionality:

• Table editing. The order of columns in the list determines the order of columns when viewing or editing the table in Open Table in Spreadsheet.
• Default sort order. For data tables, the order of the key columns defines the default sort order.
• Plan file lists. For reference tables that are specified as plan code tables, the order of the columns determines the display order of the columns in file group dialogs.

The ability to order columns in a table is limited to administrators and to users with the following security permissions: either the global Administer Tables permission, or the Allow changing table structure permission for individual tables.

To change the order of columns:

1. In the Columns tab of the Edit Table dialog, select the column or columns that you want to move.

   If you are creating a new table, you can manage columns on the Edit Columns screen of the Create Table wizard.

2. Click the Up or Down arrows until the column is at the desired location.

   NOTE: Key columns are always listed before non-key columns. However, you can change the order of the key columns. Also, columns designated as description columns (property of Describes Key) always display after the key(s).

3. Click Apply or OK to save your changes.