Over the past couple of years, the number of tables within a database has grown (probably about 50). I would like to clean it up, but as I try to delete tables from the database (either through modify database or deleting from my project), it seems to take forever for the table to be deleted (like 1/2 hour). Eventually, it is deleted. I don't know whether it matters, but the data is stored on a network drive. Any ideas on why it takes so long and if I can reduce the time it takes to delete a table?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.