/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

0 vote264 views1 answer
How to create notes in mysql
SQL
0 vote234 views1 answer
Creation d'un trigger sql
SQL
2 votes244 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote221 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote228 views1 answer
How to change the field size of an existing column
SQL
10 votes232 views2 answers
Sql rtrim
SQL
1 vote235 views1 answer
Sql server update column based on another table
SQL
0 vote245 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote223 views1 answer
Mysql group by derived column
SQL
0 vote232 views1 answer
Database timezone
SQL