Home > Management Studio, SQLServer, SQLServer 2005, SQLServer 2008, SQLServer 2008 R2, SQLServer 2012 > SQL Server – Filtering objects in Object Explorer – Management Studio

SQL Server – Filtering objects in Object Explorer – Management Studio


When you are working on a database with a large number of objects sometimes it becomes a challenge to locate objects. Object Explorer in SQL Server Management Studio lists all objects according to category and it may be hard to locate specific object.

To resolve this you can Object Explorer provides filtering for objects. You can apply a filter in Object Explorer for common object categories. i.e. Table, Views, Stored Procedures etc.

For example, if we need to locate a stored procedure which has "Sales" in name we can use Object Explorer filtering as below:

Step 1: Right Click on Stored Procedures category in required database and select Filter > Filter Settings:

image

Step 2: In the Filter Settings dialog box, specify "Sales" in Value field, and click on OK to apply filter:

image

After applying this filer Object Explorer will only show stored procedures matching the specified filter criteria, only those which have word "Sales" in their name in this case:

image

Step 3: To clear the filter and list all objects again, right click on filtered category and select Filter > Remove Filter. This will clear the filter applied.

Hope This Helps!

Vishal

  1. udi
    22.03.2013 01:25 | #1

    What about wildcards??????????????

  2. Tuan Hoang
    12.06.2014 10:04 | #2

    My filter is disable, is there any way to enable it???? I try all version from 2008 to 2014, the Object Explorer filter is disable and give me no choice but “report..” and “refresh”

    Thanks

  3. Tuan Hoang
    13.06.2014 11:02 | #3

    I found out that the filter is disabled on Oracle “linked server.” as well as the Intellisense, do I need to do any setup on the Oracle server setting to enable it?

    Thank you

  1. No trackbacks yet.