Friday, May 13, 2016

How do I select all of my sprocs in SSMS 12 for a mass delete?

  • Select the "Stored Procedures" folder under the "Programmability" folder in SSMS's Object Explorer.
  • Press F7 to open the list of sprocs in an "Object Explorer Details" pane.
  • Herein you may use the old click-and-then-click-a-second-time-while-holding-Shift trick to select everything.
  • Click the "Delete" or "Del" key.

No comments:

Post a Comment