I want to know that what we can change the ordinal position of any column in SQL Server?
because of creating a table and were wanted to some changes like auto-increment(IDENTITY) and it's not altered, so I drop the column and then again alter column and make it auto-increment(IDENTITY) but my id column ordinal position is changed and it is 8th position I want to set back on position 1 so what can it be possible or not ??????????????
Sir plz anyone of you know then tells me how this can this possible.
Sachin SinghPosted Jun 23, 2021, 3:19 PM
Rahul ChauhanPosted Jun 24, 2021, 10:08 AM
Thank you Sachin Singh done
Sachin SinghPosted Jun 23, 2021, 3:35 PM
Rahul ChauhanPosted Jun 23, 2021, 3:02 PM
Sachin SinghPosted Jun 23, 2021, 2:22 PM
Rahul ChauhanPosted Jun 23, 2021, 2:01 PM
Sachin SinghPosted Jun 23, 2021, 1:59 PM
To change the column order
In Object Explorer, right-click the table with columns you want to reorder and click Design.
Select the box to the left of the column name that you want to reorder.
Drag the column to another location within the table.