Delete query

[ryan.fitzpatrick3]

Will a delete query delete whole table or just records in table? I
have.

DELETE tblAdagePaidDebits
FROM tblAdagePaidDebits;

Will this delete the entire table or the records in that table?

ryan

 

[Douglas J. Steele]

That will delete all the records in the table, or it would if it were
written correctly:

DELETE * FROM tblAdagePaidDebits;

or simply

DELETE FROM tblAdagePaidDebits;

To delete only some of the records, you need a Where clause.

To get rid of the table, you need to use something like:

CurrentDb.TableDefs.Delete "tblAdagePaidDebits"