/SQL/How to remove identity from a column in sql server

How to remove identity from a column in sql server

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

Similar codes

5 votes308 views4 answers
Change auto increment mysql
SQL
-2 votes304 views1 answer
Group functions in sql
SQL
11 votes297 views2 answers
Having in sql
SQL
0 vote304 views1 answer
Python connect microsoft sql server
SQL
1 vote321 views2 answers
Oracle create synonym
SQL
0 vote303 views1 answer
T-SQL Never ending DELETE
SQL
1 vote288 views6 answers
In sql
SQL
4 votes297 views3 answers
Oracle sql first day of quarter
SQL
1 vote297 views1 answer
Xampp import sql file command line
SQL
2 votes310 views1 answer
Column names in oracle sql
SQL