How to remove IDENTITY from a Column of a SQL Server? The one line answer is – There is no specific way for disabling the IDENTITY on a Table Column. There are few hacky ways to do this so let me share here. Option 1: Create a replica blank table without any constraint Transfer all … Continue reading SQL Server: How to remove IDENTITY from a Column?