Reset indexes

• one-253516

  Newbie

  Points: 3

  More actions

  August 18, 2005 at 9:27 pm

  #167952

  Hi Again !

  Is there a way to reset a particular database so all of the table's indexes reset to 1 ? Just like in Access..

  The reason is, I have used the database for development and i want to try to deploy it but I don't want to re create new database.

  THanks in advance

• philcart

  SSC-Forever

  Points: 47797

  More actions

  August 18, 2005 at 9:44 pm

  #583389

  Do you mean the IDENTITY values??

  If so, check DBCC CHECKIDENT in Books Online.

   

  --------------------
  Colt 45 - the original point and click interface

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  August 18, 2005 at 9:53 pm

  #583390

  dbcc reindex ????

  probably not...not with reset to 1

  ...soliloquy time!!!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**