Hi folks,
In SSMS, it's easy to remove the identity of a column (simply set Is Identity to No). I've read that this can't be done using TSQL. Is this accurate? Thanks!
That's correct. Behind the scenes, SSMS will create a new table without the identity property on the column and then insert the data from the old table into the new one, then rename it afterward.
1 Like