SQL group tables in SQL Server Management Studio object explorer

Question

I have a table that contains about sixty tables, and other tables are constantly being added. Each table is part of a schema.

This number of tables makes it difficult to use Microsoft SQL Server Management Studio 2008. For example, I have to scroll up in the object explorer to access the functions associated with the database, or scroll each time I need to access the Views or Security functions.

Is it possible to group several tables so that they can expand or collapse them in the Object Browser? Maybe a folder can be displayed for each scheme, allowing you to collapse folders that I do not need to use?

Answer 1

In SQL Server 2008, you can apply filters to your object browsers.

Find the Filter button and click on it.

Define filter - filtering by object name and / or scheme is possible

Filtered view of your objects: