HOW TO: Remove the IDENTITY Property from an Existing Column in SQL Server 7.0 (319663)

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