Azuredatastudio: Feature Request: Tree view database schemas

Created on 15 Nov 2017 · 13Comments · Source: microsoft/azuredatastudio

SQL Operations Studio Version: sqlops 0.23.6 (8a3011756318a2ded1e6e84332230a2b2bf9c544, 2017-11-06T21:51:43.232Z)

- OS Version: Windows_NT x64 10.0.15063

Steps to Reproduce:

Navigate to database > Tables
The databases are listed without being grouped by schemas. For a large database with many schemas, the default view would be improved by a another level in the tree grouping tables/views/etc by the schema in which they reside.

Area - Data Explorer Enhancement

Source

quesog

👍32

Most helpful comment

Or, if you choose not to add this as a built-in option, at least make sure it's possible for someone else to develop a plugin that can do this. :-)

cwstanton on 23 Apr 2018

👍5

All 13 comments

Or, if you choose not to add this as a built-in option, at least make sure it's possible for someone else to develop a plugin that can do this. :-)

cwstanton on 23 Apr 2018

👍5

+1 On this. Probably the only feature for which I need to keep my Datagrip subscription going. I have hundreds of schema with hundreds of tables on dozens of servers. Without a folder organisation it becomes impossible for me to use Azure Data Studio.

It shouldn't be too hard to implement what is already used in the Visual Studio PostgreSQL Explorer extension.

dbauszus-glx on 7 May 2019

Adding another +1 to this. I use this extension in SSMS to do the same thing, if it helps?

https://github.com/nicholas-ross/SSMS-Schema-Folders

spydacarnage on 2 Jul 2019

@spydacarnage How do you use SQL Server Management Studio extensions with Azure Data Studio? Have you tested whether the extension works with PostgreSQL which I assume is not available in SSMS.

dbauszus-glx on 2 Jul 2019

@dbauszus-glx - sorry, that's not what I meant. I was meaning that if somebody wanting to code this extension wanted to look at the other project for inspiration - I don't know how close or compatible the codebases are. That extension also adds schema folders to Stored Procedures, etc. as well, not just tables.

I've not used PostgreSQL, unfortunately.

spydacarnage on 2 Jul 2019

Yup, this would be a great feature, especially now that PostGRES is supported in Azure Data Studio.
Here's a screenshot of how pgAdmin handles it for PostGRES.
pgAdmin_SchemaHandling

9squirrels on 18 Sep 2019

👍3

Plus one for this. On huge DB's such as an enterprise DWH in AzDWH (now Synapse) this is a real pain point.

spowellnet on 27 Apr 2020

👍3

+1! Would be great to have it.

pachitorusso on 2 Jul 2020

👍3

Please add this. It would be a tremendous help in better adoption. We have hundreds of tables in many many schemas. Scrolling through hundreds of tables is a real problem trying to find the table you want.