/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 vote193 views1 answer
Sql comparison operators
SQL
0 vote229 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
2 votes228 views2 answers
Mysql bidirectional composite primary key
SQL
16 votes228 views6 answers
Python sqlite
SQL
0 vote216 views1 answer
How to input data as id in database sql c#
SQL
0 vote210 views5 answers
Sql table intermédiaire
SQL
0 vote209 views1 answer
Get who is hired in january in sql
SQL
0 vote205 views1 answer
Call function in query sql server
SQL
1 vote281 views2 answers
Begin transaction sql
SQL
0 vote201 views1 answer
Renommer schema sql
SQL