reset the identity value

• palmdev2002

  SSC Enthusiast

  Points: 184

  More actions

  March 28, 2002 at 12:50 pm

  #104888

  How can I reset the identity value without needing to rebuild the table? What I wanna do is to reset to one when the identity value reach an used defined value.

  Cheers

  Dev

  
  Cheers
  
  Dev

• sarmistead

  SSCommitted

  Points: 1671

  More actions

  March 28, 2002 at 12:54 pm

  #426254

  This will reset it to 1:

  DBCC CHECKIDENT (tablename, reseed, 1)

  Steve Armistead,

  Database Administration

  Panther Systems Northwest, Inc.

  Vancouver, WA

  Steve

• palmdev2002

  SSC Enthusiast

  Points: 184

  More actions

  March 28, 2002 at 1:05 pm

  #426257

  thanks for your help, it works great.

  Cheers

  Dev

  
  Cheers
  
  Dev