Microsoft KB Archive/319663

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

Article ID: 319663

Article Last Modified on 10/26/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q319663



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 view.
 * 3) Click to clear the Identity column check box.
 * 4) Save the changes.

back to the top

Additional query words: remove identity column

Keywords: kbhowto kbhowtomaster KB319663

-

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

© Microsoft Corporation. All rights reserved.