3

In Visual Studio's Server Explorer window there's a very nice feature that lets you see the DB objects grouped by schema:

It turns this object tree:

Data Connections -> MyServer -> MySchema.MyTable

Into this one:

Data Connections -> MyServer -> Schemas -> MySchema -> MyTable

I've been looking for this particular feature in ADS but was unable to find it.

Does it exist? If not, is there a plugin which would provide this feature? Or perhaps is there a plugin which would help ease navigation in DBs which have lots of objects?

Something like this enter image description here

RaG
  • 317
  • 7
  • 19

2 Answers2

2

Right click on a Database -> "Enable Group by Schema"

enter image description here

Then you will see:

enter image description here

Adriaan
  • 17,741
  • 7
  • 42
  • 75
Matteo Rastelli
  • 21
  • 2
0

No matter Visual Studio's Server Explorer、SSMS or other tools, the all let our see the DB objects grouped by schema:

Data Connections -> MyServer -> MySchema.MyTable

If these tools don't have the feature you want, I think ADS also doesn't.

Hope this helps.

Leon Yue
  • 15,693
  • 1
  • 11
  • 23
  • SSMS has this feature but i dont find it in ADS https://stackoverflow.com/questions/24425888/group-tables-by-schema-in-ssms – RaG Aug 22 '19 at 18:08