how to refresh the table id column...after 1 year?

Oct 11 2013 6:54 AM

Hi,

How to refresh table column start with 1...........upto ....n

after 1 year i want it will again start with 1......there is no primary key for that.

Actually i am generating receipt no !

Please solve this problem and provide solution for that

Regards,
Ajit More