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.