snippetsqlMinor
How do I collapse schemas in SQL Server Management Studio?
Viewed 0 times
studioserversqlschemasmanagementhowcollapse
Problem
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:
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:
Solution
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
SSMS Schema Folders
Context
StackExchange Database Administrators Q#189329, answer score: 7
Revisions (0)
No revisions yet.