Identity Value Reset in SQL Server

--DBCC CHECKIDENT (yourtable, reseed, 34) Reset table using identity Value

 create table Reset_identity(ino int IDENTITY(1,1),name varchar(20))

  insert into Reset_identity(name) Values('Munish')

 

  select * from Reset_identity

 

  Result

  ino name

   1  Munish

   2  Munish

  

 

  DBCC CHECKIDENT ('Northwind.dbo.Reset_identity', RESEED, 10000);

 

  insert into Reset_identity(name) Values('Munish') -2 Rows inserted.

 

  select * from Reset_identity

 

  Result

  ino name

    1 Munish

      2     Munish

      3     Munish

      10001 Munish

      10002 munish

Browse More Articles

Tweet

Written by Test

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.