How to remove Auto_increment from a column in SQL Server? Let’s discuss the method in this article. Bobcares, as a part of our Microsoft SQL Server Support Services, offers solutions to every query that comes our way.

How to remove Auto_increment from a column in SQL Server?

We’ll see the method to remove the Auto_increment from a column in SQL Server:

1. Launch SQL Server Management Studio.

2. Search for Server >> DataBase >> Table.

3. Select Design with a right-click on the table.

4. Mark the column we want to change in the design window.

5. Browse to Identity Specification >> Is Identity And change to No in the Column Properties Window.

6. Visit the Toolbar menu and select Table Designer. Click on Generate Change Script.

Finally, we’ll be having the script we needed. If we must maintain the information in that column, make a new column in the table of the same type (but with a different name), copy the information to the new column, delete the old one, and rename the new one.

In MySQL Table, we can use the ‘Modify’ option to disable or remove the auto-increment from a column. E.g., if we have an employee table with the auto-increment column “idemployee” and we want to get rid of that attribute or feature, we can use the code below.

ALTER TABLE employee 
modify idemployee int(11);

[Looking for a solution to another query? We’re available 24/7.]

Conclusion

The article explains a 6-step method from our Tech team to remove Auto_increment from a column in SQL Server.