I am not sure if this is possible, but I am hoping it is – I am currently running SSMS and have a database that has it's data all "housed" in the DBO schema. I have received advice (and completely agree) that best practice will be to create additional schema's that match our business functions, and I will be moving ahead with that.
I would like to know if there is any way – even if it is by install an add-in of some kind, to have the schema collapse so that I can have all the DBO, and RPT objects hidden until I expand the schema – much like the tables and other folders are collapsed.
I apologise if this question is not quite "on topic" for this site – but I think this is where the answer is most likely to be known.
In my screenshot below – I am looking for the bit outlined in red to be collapsedand there just to be 2 lines the DBO that is there now – and the RPT which I currently have the request in to create:
Best Answer
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