Delete a Table using a Query

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
 
R

Red

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
 
Top