/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

-1 vote186 views2 answers
Postgresql get last 10 records
SQL
2 votes196 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote183 views1 answer
Sqlite get date only
SQL
0 vote192 views1 answer
What does leave do in mysql
SQL
1 vote186 views2 answers
Login to mysql
SQL
0 vote170 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote140 views1 answer
Mysql convert column to uppercase
SQL
1 vote187 views1 answer
Get last week data in mysql
SQL
0 vote181 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote189 views1 answer
Dbms_output sql developer
SQL