Skip to main content

Column order doesn't refresh in results window


Column order doesn't refresh in results window. This is a known limitation. Because of the way the code is designed, we would have to re-run the select to re-order the columns.


In the SQL Wizard, when new columns are added to the 'Columns' window and then the column order is changed, the new change order isn't reflected in the results window.  To reproduce:

Open SQL Wizard.

Add Products.ProductName column.

Add Product.ProductID column to the top of the 'Column' window.  The ProductID column is displayed at the far left in the results window.

Drag the ProductID column to be below the ProductName column in the "Columns' window.  The columns in the results window remain the same.

  • Was this article helpful?