SQL Server Management Studio (SSMS) provides very useful facility while working with large number of objects. We may apply a filter on folder of required objects and instead of retrieval of all objects under that folder filtered objects according to names will be shown under that folder and also in Object Explorer Details frame. In SSMS 2005 filtration is allowed upon Name, Schema, and Creation Date. While in SSMS 2008 filtration on owner of object can also be applied.
Right click on folder of required objects and go to Filter -> Filter Settings
Now in order to get all tables having string ‘product’ in their names, i will provide ‘product’ in name filed of filter.
After pressing OK button, i will get filtered tables under the folder and also in Object Explorer Details frame.
Similarly filters may be applied upon Name, Schema, and Creation Date in SSMS 2008. In SSMS 2008 along with these fields filters may also be applied upon owner.
For removal of filter just go to same menu and there Remove filter option will be enabled to work for you.
For any change in filter setting you may go to Filter Settings frame. Following are objects where you can apply filters
- stored procedures
- Log Ins