CODEWITHSUNDEEP
azureazure-sql-databasessmsssms-17azure-data-studio
RaG
RaG

Reputation: 337

Group tables by schema in ADS

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

Upvotes: 4

Views: 1771

Answers (2)

Matteo Rastelli
Matteo Rastelli

Reputation: 31

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

enter image description here

Then you will see:

enter image description here

Upvotes: 3

Leon Yue
Leon Yue

Reputation: 16401

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.

Upvotes: 0

Related Questions