Online Documentation for SQL Manager for SQL server

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 to view the modification script in the Changing Metadata window and apply changes.

 

Table Editor - Changing fields order

 

 

Note: This operation is performed by dropping/recreating the table.