Removing Identitiy property | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Removing Identitiy property

What is the easiest way to remove identity property from a column? I’ve tried to remove through EM and it was trying drop and re-create the table. I guess there should be an easier way than that.
Use alter table syntax. I think that should work. Refer BOL for the same. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
Gaurav – any chance you could post an example? Bambola.
I think that was an ibm hangover… http://dbforums.com/arch/200/2003/3/626607 Gotta take a break from this… Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
]]>