Drop Table if exists

  • Thread starter Thread starter Charles P. \(Pat\) Upshaw
  • Start date Start date
C

Charles P. \(Pat\) Upshaw

I have a macro which drops a series of tables and relinks those same tables
from another database. I want to condition the drop on the existence of the
table.

How do I do this in the macro condition column?

Many thanks,
Pat Upshaw
 
Sorry, Pat, this is not possible. As far as I know, the only way to
handle this with macros is to run a Make-Table Query first. If the
table already exists, the make-table will overwrite it, but that doesn't
matter because you are going to trash it anyway. If it doesn't already
exist, it will now :-) Either way, you end up with a table of the
required name in existence.
 
Back
Top