How to drop all contents from a table?

[rkw12345]

Hello all,

I am in need of a fast way to drop all the contents from a table that has over 65,000 records, it is being refreshed weekly.

Any help is appreciated.

Thanks.

 

[The_Doc_Man]

Delete query.


DELETE * FROM table-name ;

Or you can qualify it...

DELETE * FROM table-name WHERE field-1 = "XYZ" AND ... ;

 

[rkw12345]

Thank you very much, you have just saved me a morning each week that was used to empty various tables in our database.