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

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