Deleting all the elements in a table with a macro 1

[Xzibit7]

Is there anyway to delete all the records in a table(while still keeping the table format) in a automated fashion.

 

[lespaul]

this will delete all the records in a table but leave the table for future use:

DELETE FROM TableName

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[Xzibit7]

Thanks