Delete a Table using a Query

  • Thread starter Thread starter Rod Woods
  • Start date Start date
R

Rod Woods

Good day,

I am hoping someone could help me. I have a list of
tables that are linked to another database. What I would
like is an easy way to remove the tables rather than one
at a time.

Is there a way that I can set up a query to delete these
tables? I can set up a query to delete records from
within the tables, however I want to remove the tables
all together.

Rod
 
Hi Rod

Try the following query

DELETE TABLE_1.*, TABLE_2.*, TABLE_3.*, TABLE_4.*
FROM TABLE_1, TABLE_2, TABLE_3,TABLE_4;

Just add the tables you want to delete to the querie.

Red
 
Back
Top