Removing identity of column using TSQL

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