/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 vote159 views1 answer
How to check if there is no database schema
SQL
0 vote163 views1 answer
Sql server convert date to weekday
SQL
0 vote203 views1 answer
How to check database engine in mysql
SQL
0 vote161 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote199 views1 answer
Sql select rows with different values in one column
SQL
3 votes170 views3 answers
Mysqldump: couldn
SQL
1 vote156 views1 answer
Oracle aleter trigger ora-01031
SQL
1 vote173 views1 answer
Search for tables with name postgresql
SQL
0 vote171 views1 answer
Sql auto_increment syntax
SQL
12 votes196 views6 answers
Distinct in sql server
SQL