/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

2 votes146 views3 answers
Mysql kill
SQL
1 vote122 views1 answer
Get parameter value in mysql trigger
SQL
3 votes106 views2 answers
Truncate table
SQL
1 vote113 views3 answers
Mysql disable foreign keys check
SQL
0 vote160 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote112 views1 answer
Laravel eloquent get generated sql
SQL
1 vote114 views1 answer
How to print longest name in sql
SQL
0 vote105 views1 answer
Oracle archivelog usage
SQL
0 vote105 views1 answer
Oracle string length
SQL
1 vote113 views1 answer
Delete from inner join sql
SQL