SSMS - Group by Schema
SSMS
When you are using multiple schema and you have a LOT of tables SSMS makes it very hard to identify object by their schema
It would be useful if you could group all object by Schema
i.e. include an additional level in the tree view.
So the tables & Views and programability would be UNDER a schema leaf.
we have over 400 tables in do plus another 100 in other schema. I am not going to refer to schema specifc views/stored procedures etc.
The other option would be the have a schema branch within tables branch so that I can expand JUST the tables for a specific schema

1 comment
-
Guillermo L Dufourc commented
I totally agree, When you have more than 100 objects, it is a must to group objects and then schema, and to have another branch grouped by schema and then objects