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.
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.
Now, the list of objects is more manageable.