/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 vote275 views1 answer
Continue in sql
SQL
0 vote257 views1 answer
Mysql find missing values
SQL
0 vote254 views1 answer
Mysql installer no packages found
SQL
0 vote281 views1 answer
Display all node label neo4j
SQL
0 vote293 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote223 views0 answer
SQL
0 vote251 views1 answer
Number(10 2) in sql means
SQL
3 votes268 views2 answers
Sql end of month
SQL
0 vote265 views3 answers
Osx stop mysql service
SQL
0 vote306 views1 answer
Psql create usr
SQL