Link to home
Start Free TrialLog in
Avatar of Mike Eghtebas
Mike EghtebasFlag for United States of America

asked on

Deleting sql table

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.
SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial