I've never experienced dropping two objects when trying to drop one.

My guess is that using something like the sp_MSforeachtable stored procedure would drop all matching objects if you don't specify a schema (owner in older versions). It depends on current and default schemas and security rights at the time of execution.