/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 vote142 views1 answer
Mysql backup skip table
SQL
2 votes139 views5 answers
Tablespace ORACLE
SQL
0 vote136 views1 answer
Postgres enumerated type
SQL
3 votes171 views1 answer
Mysql cli connect with password
SQL
0 vote137 views2 answers
Temp tables in sql server
SQL
0 vote193 views1 answer
Sql int vs integer
SQL
-2 votes159 views1 answer
Mysql not empty
SQL
0 vote146 views8 answers
Convert sql query to linq online
SQL
2 votes135 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
16 votes133 views2 answers
Gremove folder from git
SQL