Menu ▼



Posted By :
avatarmrkraju
Total Views : 357

SQL Query to reset the Identity

When you truncate the table data, table Identity will be reset automatically. But when you delete the records in the table Identity will not be reset.

Below query will reset the table Identity in SQL server.

DBCC CHECKIDENT ('[TableName]', RESEED, 0);
GO






comments powered by Disqus


Search dotnetlearners.com