Delete query

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

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
 
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"
 
Back
Top