If I understand your question correctly, you would like to drop and recreate the table in order to reset the auto-incremented key for the table.
Before going to the details you should consider if you need to reset the auto-increment field at all. Auto-incremented keys are also called
surrogate keys[
^]. The point with this type of key is that the value is unique but meaningless to the application or to user. The sole purpose is to identify the record. So even if you have 1000 rows in the table, you delete them all, why does it matter if the id for the next record inserted is 1001? It shouldn't.
If there is a solid reason to reset the id: While you could drop and re-create the table it probably would be easier just to reset the auto-increment after you have deleted
all the rows. Looking at the documentation
The content of the sqlite_sequence table can be modified using ordinary UPDATE, INSERT, and DELETE statements. But making modifications to this table will likely perturb the AUTOINCREMENT key generation algorithm. Make sure you know what you are doing before you undertake such changes.
So once yo have deleted all the rows you can set the increment value to zero using a statement like
UPDATE SQLITE_SEQUENCE
SET seq = 0
WHERE name = 'Import_Data'
IMPORTANT! If you don't delete all of the rows, you don't want to set the value to something that would generate duplicates. In such case you would fetch the greatest value from you table and use that for the next value. Something like
UPDATE SQLITE_SEQUENCE
SET seq = (SELECT MAX(id)
FROM Import_Data)
WHERE name = 'Import_Data'