/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 vote290 views1 answer
Oracle plan hash value
SQL
0 vote266 views1 answer
Sql select upcoming birthdays
SQL
0 vote267 views2 answers
Uninstall postgresql mac
SQL
0 vote244 views1 answer
How to check if there is no database schema
SQL
0 vote265 views1 answer
What is between keyword used for
SQL
0 vote254 views1 answer
Mysql grant user wildcard database
SQL
0 vote282 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
4 votes287 views2 answers
Postgresql float data type
SQL
3 votes256 views2 answers
Sql get month name
SQL
0 vote200 views1 answer
Oracle sql replace string in clob
SQL