SQL Server: SSMS Object Explorer Filter

Leveraging the Object Explorer Filter to work more efficiently.

The SQL Server Studio Manager’s primary interface to database objects is the object explorer.
While this tool is very powerful, the results it displays can be quite overwhelming, especially in a production environment.

To make locating objects more efficient, the explorer provides the ability to filter results based on a number of configurable parameters.
In the following example, I will illustrate how to search for objects that contain “log” within its name.

At first the explorer displays all objects.

object-explorer-filter-before

I’ll begin by selecting the filter button near the top menu.
Then, I will enter the string “log_” as the filter parameter so that only objects with that word in its name will be displayed.

object-explorer-filter-config

Now, the list of objects is more manageable.

 

object-explorer-filter-after

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s