Microsoft KB Archive/319664

= HOW TO: Remove the IDENTITY Property from an Existing Column in SQL Server 2000 =

Article ID: 319664

Article Last Modified on 12/12/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 64-bit Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q319664



IN THIS TASK
SUMMARY
 * Use Enterprise Manager to Remove the IDENTITY Property



SUMMARY
This article describes how to remove the IDENTITY property from an existing column of a table.

back to the top

Use Enterprise Manager to Remove the IDENTITY Property
To remove an IDENTITY property from a column:
 * 1) Start SQL Server Enterprise Manager, expand Databases, and then expand the database of your choice.
 * 2) Click Tables, right-click the table from which you want to remove the IDENTITY property, and then click the Design Table view.
 * 3) Under the Columns editing section that appears at the bottom of the page, click Identity, and then click No.
 * 4) Save the changes.

back to the top

Additional query words: remove identity column

Keywords: kbhowto kbhowtomaster KB319664

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.