/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 vote241 views1 answer
Sqlite unique multiple columns
SQL
0 vote214 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
22 votes251 views3 answers
Year format in date mysql
SQL
2 votes220 views2 answers
How to get capital letter first in sql
SQL
0 vote197 views1 answer
Split a string with expression and get the last value of split sql
SQL
1 vote218 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote210 views1 answer
Check index sql server
SQL
0 vote239 views1 answer
Mysql subtract month from timestamp
SQL
1 vote243 views1 answer
How to fetch alternate records from two tables
SQL
0 vote229 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL