How to reset Identity Column in SQL Server.


Posted on July 27th, 2015 by Hitesh Kumar | 321 Views

Query to reset Identity Column

DBCC CHECKIDENT ('Table_Name', RESEED, 0)

Note : Table_Name is the table name in which identity to be reset.

Related posts:

  1. How to find Identity Column in SQL Server?
  2. How to get Referenced Table and Column Name in SQL Server.
  3. What is difference between DELETE & TRUNCATE commands?
  4. How to remove leading zeros from column in table.