Group tables by schema in SSMS

2020-06-16 01:51发布

问题:

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.

回答1:

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



回答2:

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.



回答3:

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

There you are able to filter by schema...