DBCC RESEED Table Identity Value – Reset Table Identity

If You want to reset the Identity value in your table,like you want to start next row of your table from say identity 30,you can use as

DBCC CHECKIDENT (yourtableName, reseed, 30)

Now if you want your table to start with an identity of 1 with the next insert then table should be reseeded with the identity to 0

Comments (1)
Posted by: Rishabh Toshniwal

Categories:

30. January 2012

Tags:

Comments (1) -

Deepak Sharma United States

January 31. 2012 01:54

Deepak Sharma
Hi,
DBCC CHECKIDENT (yourtableName, reseed, 30)
Query will be working for all RDBMS or just working for sql server.

Thanks

Add comment

  Select your country

biuquote
  • Comment
  • Preview
Loading