IDENTITY Property | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

IDENTITY Property

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.
Moderator
SQL-Server-Performance.com
]]>