Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    Southern California
    Posts
    1

    Unanswered: delete all data and restart key count to 0

    How do I clear all the entrys from a table and make the keys start all over

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    If u need the current records again u can copy the records to some new table drop the identity column and create it again with the proper seed and import the data back from the temp table.

  3. #3
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    truncate table will remove all data and reset the IDENTITY counter to the original seed
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •