delete the whole table

[AlexBen]

Good day! Beside clicking DEL from the keyboard, is there a way (code) to delete the whole table? not just the content. It is when am importing data from excel, there's a dump table created. Thanks in advance!

[orange]

currentdb.execute "Delete * From YOURTABLENAME_HERE ;" <<deletes records

currentdb.execute "DROP TABLE table_name;" <<<deletes table and data

[Welshgasman]

currentdb.execute "Delete * From YOURTABLENAME_HERE ;" <<deletes records

currentdb.execute "DROP TABLE table_name;" <<<deletes table and data

@orange
Why the delete, when the drop gets rid of everything in one go?

[Micron]

Doesn't repeatedly deleting and recreating the table cause db bloat? At least I'm guessing that the import from Excel is going to happen over an over again. When importing, you have the option to overwrite the whole table without deleting or append to it, no? Have to confess I have not done much of that so I'm asking more than suggesting a route to take.

[Welshgasman]

When I created a small DB for a UK bank I was working at, I had to import a stupidly large Excel sheet (for what we needed at least), and find what we needed.
Now I realise linking to a static named workbook would have been better, and failing that a side DB for any imports. The DB bloated regularly.

Alas, that knowledge is now moot, as I retired.

That is where Foxpro comes into it's own, as well as the much better speed, the ZAP command.

[orange]

Paul,

I provided both Delete and Drop more for info/instruction since the OP doesn't seem to be aware of either.
Regarding other points in the thread -- bloat etc, I think we need to know more about the processes involved and context. Often wise to do C&R and bkup during periods of multiple loading/processing/deleting.