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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-18 : 10:04:25
|
| Mitch Kline writes "I would like to reset an autonumber field to 1 after deleting records from a SQL table, so when I add a new set of records, the starting number is not one more than the greatest number in the last set of data, but one. Is this possible? Thanks for your help!Mitch Kline" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-03-18 : 10:04:25
|
| There's an article on our home page right now that shows how to do this: http://www.sqlteam.com/item.asp?ItemID=8003 |
 |
|
|
|
|
|
How do I reset an autonumber field to start at 1?