:::: MENU ::::

Use filter for objects in SQL Srever Management Studio (SSMS)

  • Apr 21 / 2009
  • 0
dbDigger, SSMS tips and tricks

Use filter for objects in SQL Srever Management Studio (SSMS)

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

Filter settings in SSMS

Now in order to get all tables having string ‘product’ in their names, i will provide ‘product’ in name filed of filter.

Apply filter in SSMS

After pressing OK button, i will get filtered tables under the folder and also in Object Explorer Details frame.

Filtered Tables in SSMS

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.

Remove filters in SSMS

For any change in filter setting you may go to Filter Settings frame. Following are objects where you can apply filters

  • tables
  • views
  • stored procedures
  • functions
  • Log Ins
  • jobs
Consult us to explore the Databases. Contact us