Web lists-archives.com

Re: deleting big tables




Hi Pau,

Ideally drop table should not take that much time , you have to check if
your command is executing or it is in waiting stage. May be you are not
able to get lock on that table.

Cheers,
Adarsh Sharma

On Sat, 16 May 2015 at 23:34 Pau Marc Muñoz Torres <paumarc@xxxxxxxxx>
wrote:

> Hello every body
>
>  i have a big table in my sql server and i want to delete it, it also have
> some indexes. I tried to "drop table" and "delete" commands but i
> eventually get a time out. Wath can i do with it, does it exist any method
> to delete tables quicly?
>
> i know that drop and delete are not equivalent but i want to get rid of all
> information inside
>
> thanks
>
> Pau Marc Muñoz Torres
> skype: pau_marc
> http://www.linkedin.com/in/paumarc
> http://www.researchgate.net/profile/Pau_Marc_Torres3/info/
>