Find All tables in a Database and delete them?

  • Thread starter Thread starter RocketDude
  • Start date Start date
R

RocketDude

Hi,

How do I find all of the tables that exist in the current database, and then
delete them using VBA?

TIA,
 
you can use TableDefs collection to get all tabledef objects, which are
represent tables.
but please note that it also contains system tables MSys*, which you can't
delete.

also you can make a query on MSysobjects table
 
Back
Top