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.