Adding Identity to an existing table in SQL Server

In this article, I would like to explain about how to add IDENTITY column to the existing table.

Let’s create a table and insert below records:

CREATE TABLE DOMAIN (DOMAIN_ID INT,DOMAIN_NAME VARCHAR(30),DOMAIN_DESC VARCHAR(100))

Insert below data:

Now the task is to add IDENTITY property to the DOMAIN_ID column.

Do you have any ideas or suggestions to which can guide me to complete this task !!!

Please check out How to Add Identity to Existing Column article for the solution.

Similar Articles:

How to Add Identity to Existing Column