Menu
When I create a new table that need an ordering defined by the user, my first idea always go to a column name "order". Of course, this is NOT good since it's a reserved word.
Which name are you giving to that column in your database models ?
399
When you hover over the table name you would see three icons, click on settings (that is the one in the middle) or you can right-click and select Alter Table , then click on the column and drag it to the position you want your column to be. on your bottom right you will see apply (click and apply🙂).
Yes, column order does matter.
In theory, every statement in SQL Server create virtual table passed to next statement. In other words, when FROM and Where clause are finished, next step is SELECt columns from virtual group created step before. But, it is possible to order result set by column that is not listed in select list.
I use "position" in place of "order"
81
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
