Resent ID to 1?

Results 1 to 2 of 2

Thread: Resent ID to 1?

  1. #1
    Join Date
    Dec 1969

    Default Resent ID to 1?

    Is there a way in SQL2000 when clearing out a table to refresh and reenter all of the data to reset the ID column to 1 w/o having to delete the column, all of it's relationships, and then recreate it?

  2. #2
    Join Date
    Dec 1969

    Default RE: Resent ID to 1?

    use <BR><BR><BR>DBCC CHECKIDENT (Tablename, RESEED,1)

Posting Permissions

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