how to delete all rows in table with temporary data

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I need to fill out some table with temporary data.
I'm using append query to transfer data there. But, before
I need to delete old data.

I can delete the whole table and create a new one with the
same name and insert data there. But, it would be much
more easier just to delete all rows instead of deleting
and recreating whole table.
I would appreciate if anybody could advise whether the
approach like this exists and how it can be used.

Thanks
 
Alex,
the sql would look like this:
DELETE * FROM YourTable
This deletes everything from your table, but leaves the table structure
intact.
RD
 
Thanks a lot.
-----Original Message-----
Alex,
the sql would look like this:
DELETE * FROM YourTable
This deletes everything from your table, but leaves the table structure
intact.
RD




.
Click to expand...
 
Back
Top