I have a table (20 columns, 140,000 rows). It is imported from an Access database. I want to delete it to re-import it again because some extensive changes in both meta data and row data.
I started running Delete From Table1 but after about 10 minutes, I canceled it thinking I can just execute Drop Table Table1 but this was taking too long as well.
Now I am running Truncate Table Table1 but after 25 minutes it is still running.
Question: What is the best way do delete a table like this?
SQL Server 2012 Express.
BTW, I right-clicked on this table and chose delete option but it wasn't able to drop it.