Group Tables By Schema in Object Explorer
For efficiency, it would be nice that, in object explorer of MSSMS, tables be grouped by schema.
Group by Schema; Search/filter by name right in object explorer
Please, also add a button to the top of Object Explorer to swith between options:
- Order by: Object Type --> Object Name (current behaviour)
- Order by: Object type --> Schema --> Object Name
- Order by: Schema --> Object type --> Object Name
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.