Prev Next

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

Use one of the methods outlined here to display a list of columns for a Table, then select a column and reposition it within the list.

Ribbon

Specialize > Tools > Database Builder > Click on Table

Context Menu

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

Keyboard Shortcuts

F9

Change the column order

Step

Action

See also

1

In the 'Columns' tab, click on the required column name in the list.

2

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 'Columns' tab and on a diagram.

Learn more