Interested to learn more - Click Below

Let us know to help you out quickly!

Reset Identity Column Value

Easiest way to reset the identity column value in MSSQL is to use 'TRUNCATE TABLE' on the table.This will reset the identity column value.This will work only if the table has no references made by any child.Syntax:

truncate table TABLENAME;

For tables that are referenced by other tables we can use 'DBCC CHECKINDENT' Syntax;