Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

way to delete all rows in a table

Status
Not open for further replies.

keak

Programmer
Sep 12, 2005
247
CA
Hi there,
Is there a way in MS Access interface to delete all rows in a table? (leave the fields definitions in but an empty table)

I've tried to look it up but can't seem to find a straight forward way to do it.

any help is great!!!
thanks :)
 
Create a delete query on all records in your table

DELETE tblTableName.*
FROM tblTableName;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top