DBTeam (11/17/2009)
how long it will take to drop it..
How long is a piece of string?
There's no simple answer. Depends on the size of the table (in MB), the other activity, the IO performance and a whole lot of other factors.
Try it out on the dev system, see how long it takes.
Edit: I suggest you don't use the design view, it'll likely time out. Write a script and run it in a query window.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass