SSMS-Schema-Folders
SSMS-Schema-Folders copied to clipboard
View Tables, Views and Sprocs in single schema node
It would be great if all the tables, views, sprocs etc could be viewed under a single schema node: still have to travel up and down the full tree to see all the related stuff for a single schema, instead of ok, I'm working on payroll now, so the payroll node has all my tables, views, sprocs, etc
-schemas
-payroll.
+tables
+views
+sprocs
I wanted to do this. My original idea was for custom search folders that could contain objects of all types. But a lot of the classes used by the object explorer are internal and cannot be used without using reflection.
It is still possible to do what you want. I would need to remove the tree nodes from their original location after their object folder is opened (they are lazy loaded and cannot be cloned). Not sure if this will cause any issues.