How do I collapse schemas in SQL Server Management Studio?
I did a bit of hunting after @LowlyDBA gave his answer, and came across an extension to SSMS that does exactly what I was looking for!
SSMS Schema Folders
The closest you can come would be to filter out those schemas temporarily:
- Right click on "Tables".
- Select "Filter -> Filter Settings" and filter out the schema you don't want to see.
This should apply to all reasonably recent versions of SSMS.
Most generic DB tools that work with multiple products will offer this ability since they often utilize the schema concept more - you could try a different tool (like 0xDBE or something similar) if you really want this functionality, but you'd be giving up a lot of the MSSQL-specific functions of SSMS.