/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

7 votes175 views3 answers
How to check table name in current database sql
SQL
16 votes180 views6 answers
Mysql find and replace
SQL
31 votes173 views1 answer
Postgresql add column with constraint
SQL
0 vote173 views1 answer
Sql injection mitigation
SQL
0 vote236 views1 answer
Isnull in sqlite
SQL
0 vote228 views3 answers
Mysql keyword search
SQL
13 votes189 views4 answers
What is sql
SQL
0 vote173 views1 answer
Oracle index hint
SQL
0 vote185 views2 answers
Sql query in dax power bi
SQL
2 votes270 views2 answers
Mysql compare datetime to another datetime
SQL