I have many tables in SQL Server database. I would like to apply the filter setting on the tables, see screenshot below.

If I would like to filter all table name starting with K, I can write K in Name row, Value column and it shows me all tables which contains K letter.

What if I would like to show all tables with contains K and L letters. How should I set this multiple criteria? It shows no table if I write e.g. K, L. Any possible solution?

enter image description here

CodePudding user response：

There is no way to write multiple conditions with OR logic in SSMS.

Check this link

The other approach it to query the sys.tables metadata table

 SELECT 
     name 
 FROM sys.tables 
 WHERE name = 'L%' OR name = 'K%';