Group tables by schema in SSMS

Question

In Visual Studio's Server Explorer window there's a very nice feature that lets you see the DB objects grouped by schema:

It turns this object tree:

Data Connections -> MyServer -> Tables -> MyTable (MySchema)

Into this one:

Data Connections -> MyServer -> Schemas -> MySchema -> MyTable

---

I've been looking for this particular feature in SSMS but was unable to find it.

• Does it exist?
• If not, is there a plugin which would provide this feature?
• Or perhaps is there a plugin which would help ease navigation in DBs which have lots of objects?

Please note I'm aware of SSMS object filters. It's better than nothing but not sufficient, as I'm often accessing objects from multiple schemas at once.

Answer 1

I love the idea of grouping by schema.

SQL Treeo SSMS Addin is an inexpensive tool that allows you to create your own table structure in the Object Explorer.

Answer 2

If you want a free tool, SSMS Schema Folders (GitHub repo) is your solution. It does the job beautifully.

Answer 3

You can try as follows in SSMS: Tables > Filter > Filter Settings

There you are able to filter by schema...