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.

  • I did a quick Google search and it's been requested and denied at least four times on Connect. Sad. I really want this, too. – Jon Seigel Sep 25 '13 at 17:33

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

  • It will be cool if you can filter by status - Online, Offline – Kyle Johnson May 26 '17 at 13:55

No, it is not possible to filter this list within SSMS. My recommendation is to write a simple query reaching out to the system catalog view, sys.databases.

select name
from sys.databases
where name like '%<Your Search String>%';

Or some variation of that query, depending on what information you're looking to pull (I assumed only name, as the Object Explorer would provide you).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.