Re setting seed value of table after deleting rows

• pravarap

  SSC Enthusiast

  Points: 163

  More actions

  July 16, 2008 at 2:17 am

  #210002

  Hi,

  I have a table, i want to reset the seed value of the table after deleting few or all records from the table. Could anyone please tell me the command for the same, which i can use in stored procedure.

  Thanks in advance:)

• Grant Fritchey

  SSC Guru

  Points: 399278

  More actions

  July 16, 2008 at 4:41 am

  #843666

  Check this in the Books Online for details:

  DBCC CHECKIDENT(TableName,RESEED,1)

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• pravarap

  SSC Enthusiast

  Points: 163

  More actions

  July 16, 2008 at 6:13 am

  #843710

  It works!!!:Wow:

  Thanks a lot:)