HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

Is it possible to filter the list of databases in the Object Explorer of the SSMS?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thessmsdatabasesexplorerpossiblefilterlistobject

Problem

I know how to filter the list of tables - using the filter icon. However, this icon is disabled when the Databases node is selected.

Still, I am wondering whether it is possible.

Solution

This is now possible if you are using SQL Server Management Studio 2016. You can filter databases by Name, Owner and Creation Date.

I'm using SSMS build number 13.0.15900.1 - you can download a stand-alone version from Microsoft or just use this link: https://msdn.microsoft.com/en-us/library/mt238290.aspx

Context

StackExchange Database Administrators Q#50493, answer score: 8

Revisions (0)

No revisions yet.