Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Resetting an auto-increment column

Author  Topic 

daniel.newman@bis-web.net
Yak Posting Veteran

71 Posts

Posted - 2001-07-23 : 11:00:42
hi all,

I've got a table that I've been adding a lot of test data to. Now when I want to make it live, I need to remove all of the test records, and would prefably like to start the auto_numbering at 1 again. Is this possible?

Thanks,
Daniel.

   

- Advertisement -