bmckenna6 wrote:

> I'm a bit new to dropping tables, and I thought I had it solved
> but apparently not:

Don't bother to delete records from a table you're going to drop.
Dropping the table releases data space and indexes. You're cleaning a
house before burning it down.

That said, you can't drop a table if an existing connection (including
your own) has referenced data in it - that connection might come back
and try to reference more data and get a nasty surprise.


Regards,


Ann