September 25th, 2003, 02:06 PM
resetting an autoincrement field
Does anybody have an idea of how to reset an autoincrement field in a mysql table. I mean suppose i have 20 records..So that new records get 21 as autoincrement value.Now I delete first 10 records.Is there any way that the remaining records adjust so that new records go at 11 instead of 21.
September 25th, 2003, 04:42 PM
Look at DBCC CHECKIDENT in books online
September 28th, 2003, 05:46 AM
What does books online refer to? Pls suggest where to look DBCC CHECKIDENT for?