SQL Server – How to Collapse Schemas in SQL Server Management Studio

sql serverssms

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:

enter image description here

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

Related Question