Reorder Database Table Columns

If you have several columns defined in a database Table, you can change the order in which they are listed. The order in the list is the order in which the columns appear in the generated DDL.

Access     In diagram, right-click on required Table | Features & Properties | Attributes > Columns

Change the column order



See also


In the Columns tab of the Columns and Constraints dialog, click on the required column name in the list.




Right-click and select the:

·Move column '<name>' up option (or press Ctrl+up arrow) to move the column up one position
·Move column '<name>' down option (or press Ctrl+down arrow) to move the column down one position


These options have an immediate effect both in the dialog and on the diagram.



Learn more