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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete messages in Access table

Status
Not open for further replies.

BD26

Technical User
Jun 14, 2001
1
CA
Hi,
I was wondering how I can easily delete all records from my table.

The SQL statement that I was trying is:

Statement = DELETE from BOARD ALL

"BOARD" is the name of my table.

thanks in advance.
 
Delete * from Board;

This will delete all records/fields in your table.

Brendan
 
or, just
delete from Board;

( as long as you don't have a where clause, all records will be deleted ) Jim

oracle, vb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top