Occasionally, there is a need for us to manually delete a large number of staging tables from some of our databases. This can also occur to our partitioned tables that sometimes leave the switched partition on the list of tables in the database. But through the Object Explorer window in SSMS, it’s not possible to select more than one table at anyone time. You could script it out using T-SQL, but if there is also the Object Explorer Details window in SSMS, which you can open by pressing F7 or going to View -> Object Explorer Details

ood2

Now when you navigate over the “Tables” folder in the database that has all the tables you want to drop, you’ll see in the Object Explorer Details window all the tables. You can then select all the tables or a subset by pressing shift, and skip over others by pressing ctrl, just like you would with files through Windows Explorer.