That's a useful SP!

To give it extra benefit you could add some checking for constraints on the object (e.g. FK on the table to be dropped) and add an option to remove the constraint(s) before dropping the object.

Cheers,

Rob.