How to filter the object list in SQL Server Management Studio

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.

SQL Server filter table objects

Leave a Reply

Your email address will not be published. Required fields are marked *