In SQL Server Management Studio to filter your tables, views, stored procedures etc. list right click on the object type and select Filter -> Filter Settings. There are a number of options to filter by including name, schema and creation date but the specific filters may vary slightly by object type.
Filtering is useful when you have a large list of objects and only want to work with a subset of them.
In the example below I want to work with tables which contain my lookup/static/dropdown list values so I’ve filtered to only show tables which have the word ‘type’ in their name. Naming convention is obviously important here.
