/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 vote333 views2 answers
How to tun mysql on ubunto
SQL
16 votes381 views1 answer
Sqlserver add column to table
SQL
1 vote358 views1 answer
How to get the date diff on once field in sql server
SQL
22 votes363 views3 answers
Year format in date mysql
SQL
4 votes415 views1 answer
How to check last gather stats on table in oracle
SQL
3 votes336 views1 answer
Null sql
SQL
0 vote372 views1 answer
How to inner join 4 tables in sql
SQL
11 votes362 views1 answer
Ddl view
SQL
1 vote351 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote396 views1 answer
Mysql dump for selected row
SQL