If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in the Object Explorer can be a pain. Thankfully, SSMS allows you to apply filtering criteria to this. Just right-click on the node that you want to filter, select Filter, and then Filter Settings to set the filter that you want to use:
Once you have set the filtering criteria and clicked the OK button, that node will only show the items that match the criteria. You can even set this to a value that won’t match any objects – so you can prank others and make them think that all the tables have been removed from your production database.
This post is for day twenty of my month-long blog series “A Month of SSMS Tips”. I have a landing page for the series at bit.ly/MonthOfSSMS. Please visit this page for an easy place to quickly view all of the other tips in this series.
The post Object Explorer Filtering (Day 20) appeared first on Wayne Sheffield.
