Online Documentation for SQL Manager for InterBase/Firebird

Changing fields order


The Reorder Fields dialog allows you to change the fields order in the table.

 

To open this dialog, open the table in Table Editor, proceed to the Fields tab there, right-click within the Fields list and select the Reorder Fields item from the context menu.

 

The fields are displayed in the Column name list in the current order.

To change the fields order, use the btnReorderItems_MoveUp btnReorderItems_MoveDown buttons or drag-and-drop operations within the list. Click the OK button and compile the table to view the modification script in the Compile window and apply changes.

 

Table Editor - Changing fields order