IDENTITY Property | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


Is it possible to drop the identity property on a table without deleting the data or dropping the id column from the table?

Dropping the identity property of a field will not affect the existing data or drop the field.

Simply: ALTER TABLE [YourTable]
ALTER COLUMN [IdentityColumn] int NOT NULL and check BOL for more details on the ALTER TABLE syntax. Nathan H.O.