Admin User     Feb,08 2017

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;
use databaseName;goDBCC CHECKIDENT ('tableName','reseed',reseedvalue)go