is there any way to auto-incrementing field get auto reset after delete of any field
suggestion expected
thanks
is there any way to auto-incrementing field get auto reset after delete of any field
suggestion expected
thanks
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.
FOR HSQLDB 2.0v
Try this. Search for restart. The best is to create a trigger that will restart counter after a delete is made.