Rahul Chauhan

Rahul Chauhan

  • 1.8k
  • 429
  • 18.7k

What we can change Ordinal Position of any column ?

Jun 23 2021 1:56 PM

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.


Answers (7)