Auto reset of auto-incrementing field after delete of any field

is there any way to auto-incrementing field get auto reset after delete of any field

suggestion expected


Are you looking for a general solution independent from database used (Mysql, internal HSQLDB etc.) or you are working with a spceific DB? The approach will be different. Specific solution may work faster.


Try this. Search for restart. The best is to create a trigger that will restart counter after a delete is made.