Delete query

[ryan.fit...@safeway.com]

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"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

<ryan.fit...@safeway.com> wrote in message
news:79c99337-2c79-4067...@p10g2000prf.googlegroups.com...