1If you need to keep the data, but remove the IDENTITY column, you will need to:
2Create a new column.
3Transfer the data from the existing IDENTITY column to the new column.
4Drop the existing IDENTITY column.
5Rename the new column to the original column name.
6