rgb192
asked on
set index to 1
i deleted all the rows of my table
but the 'id' auto increment column is still at the same number
I want it to start at 1 again
but the 'id' auto increment column is still at the same number
I want it to start at 1 again
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
TRUNCATE not only removes all the rows but it also does it faster and it resets the Identity column's seed so that it starts at 1.