Group Tables By Schema in Object Explorer
For efficiency, it would be nice that, in object explorer of MSSMS, tables be grouped by schema.
The open source IDE have this feature for decades ago, but SSMS until now hasn't this.
Benoit Massy commented
I don't know what is so difficult to do this request. Cmon Microsoft, your customers ask it. Please do it!
Keith Ramnanan commented
For now we have to use this extension: https://github.com/nicholas-ross/SSMS-Schema-Folders
Please include this feature built-in to new releases
David Lean commented
FYI, This request has been made a many times. In just the 1st 3 "pages" of this forum I've found 5 requests all for the same thing as this suggestion.
Had we all searched for our request prior to raising a new one, you might discover that this is a highly sought after feature. As scrolling thru hundreds of tables & views sucks (is very unproductive). As does typing the table name into the filter each time you want a new table.
Please consider a menu button in Object explorer pane. where we can toggle "enable/disable" the schema grouping nodes, for the database in question. That way you don't have pointless levels of schema groups where there is only 1 schema (dbo) or only a screenful of tables or only a few tables in the schema. But do get the collapsed schema node when there are more than ~10 tables in the schema or lots of schemas in the database.
Below are suggestions for the same thing:-
(sometimes CLOSED as respondee clearly didn't understand the request & so talks about MS documentation)
Probably some more suggestions requesting this. I stopped looking after scrolling down 3 screens
Alan Ball commented
I think the author means specifically of ease of use. This would be hugely beneficial to enterprise customers who have a lot of tables under one database as a way to organize them into some kind of logical group.