can't you "drop cascade" to take care of any dependancies?
Never mind. Oracle great, SQL/Server sucks.
You need to exec sp_depends and drop the results of that. Of course, for each of those, you would need to do the same thing.
Recursion at it finest.