View > Object Explorer Details - select the objects you want to delete, right-click, and delete.

In future, make sure you have the right execution context before running a script. Next time it might be a DROP TABLE and you're running on Production.