Reset autoincrement column on import

General
1

Hi,

I have a table with an autoincrement column “ID”. If I have data and then clear the table, on re-importation the ID data continues from the last number.

How can I get it to restart from 1?

Thanks
Steve

2

Try deleting and recreating the column after you clear the table. That should do the trick.

Regards,
Mark

3

Yes, I did that.

Thanks