SSMS Tips and Tricks

Productivity Driven Development

Manipulate Multiple Objects Using Object Explorer Details

| Comments

You can manipulate objects one at a time within Object Explorer, but one of its frustrating limitations is that you cannot select multiple objects and script or delete them together. You can get around this by pulling up the Object Explorer Details window (View->Object Explorer Details) and clicking on a folder (such as Tables) in Object Explorer. Now you will see a list of all the objects inside that folder in the Details Window, and you can select multiple objects and manipulate them here by holding the Shift or Ctrl keys.

Want to learn more about SSMS? Check out this Pluralsight course.
Use SqlSmash to write maintainable SQL scripts, understand code faster and navigate around easily in SSMS.