Find All tables in a Database and delete them?

R

RocketDude

Hi,

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

TIA,
 
A

Alex Dybenko

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
 
Top