Avatar of Mike Eghtebas
Mike Eghtebas
Flag 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.
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Vikas Garg

8/22/2022 - Mon
SOLUTION
Vitor Montalvão

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Vikas Garg

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck