How to set Auto Increment to one 1 even after deleting records in SQL Server
How to set Auto Increment to one 1 even after deleting records in SQL Server
IMPORTANT NOTE: =========================================== Make sure to delete all the data in the table before entering the line of code. ==============================================
1)Go in your Sql Server database.
2)Select your database.
3)Open your Table whose id you want to reset.
4)Click on Select top 2000 rows.
5)Delete all the data present in your table.
6)In your appeared tab enter the following line.
DBCC CHECKIDENT('tablename',reseed,0)
![Complete online adult ballet center [30 minutes]](https://images.videosashka.com/watch/IgZEpRMQ-cE)
