• subscribe
Search
Browse By: Author | Issue
August 24, 2004 12:00 AM

Deleting an IDENTITY Column

Microsoft's Sql Server Development Team
SQL Server Pro
InstantDoc ID #43631

Can I use a T-SQL script to delete an IDENTITY column?

T-SQL's ALTER TABLE statement doesn't support dropping the IDENTITY property in SQL Server 2000 or 7.0. Your only option for deleting an IDENTITY column is to create a new table structure without the IDENTITY column, then copy the data into this structure.



ARTICLE TOOLS

Comments
Add A Comment
  • Chris
    5 years ago
    Aug 23, 2007

    what about 2005?

  • yukonguy
    8 years ago
    Sep 09, 2004

    Your question and answer are confusing each other. You can certainly drop a column that has the identity property. I think your question meant to read, "Can I use a T-SQL script to remove the IDENTITY property for a column?"

You must log on before posting a comment.

Are you a new visitor? Register Here

© 2012 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.