CODEWITHSUNDEEP
sql-servervisual-studiossms
Lucas Trzesniewski
Lucas Trzesniewski

Reputation: 51430

Group tables by schema in SSMS

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

VS feature

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

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.

Upvotes: 22

Views: 14753

Answers (3)

Rafet
Rafet

Reputation: 936

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

Folder per each schema

Upvotes: 25

David Atkinson
David Atkinson

Reputation: 5909

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.

Upvotes: 3

Muthu
Muthu

Reputation: 86

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

There you are able to filter by schema...

Upvotes: 1

Related Questions