Vscode-mssql: Feature Request: Show database hierarchy in solution explorer

[bansalvks]

is it possible to show the table and column hierarchy in solution explorer for you? something like shown in the screen shot below?

[joeygreen]

This is what I've been using in the mean time to get a list of tables. Hope it helps a little.

SELECT TABLE_NAME1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG=''

[kevcunnane]

Thanks for this suggestion. VSCode has an experimental API that would support an object-explorer like view. We won't be able to visualize this without this API being made official, but if it does become official we can look at implementing this.

[anthonydresser]

@kevcunnane If the api doesn't go through, another web application could be made in the same light as the results grid 🙄

[kevcunnane]

Another user has requested this - see #875. It looks like the API to enable this might be implemented soon as it's on the May roadmap for VSCode: https://github.com/Microsoft/vscode/issues/26068. We can consider implementation of this if the API is made public and included in full builds.

[alohaninja]

Hope to see "Support to contribute a tree section to the explorer" Extension API get knocked out soon!

Thanks @kevcunnane!

[tadcrazio]

This would be huge. Love the work done so far in this extension. Can't way to see things like this come into the project in the future .

[richarddavenport]

Any movement on this, now that there is a tree view in the explorer?

[alohaninja]

@richarddavenport - looks like this may have taken a slightly different direction. Rather than building and expanding mssql extension for vscode - they created SQL Operations Studio which leverages the treeview and vscode codebase. So nice to see a dark themed capable SSMS-style tool!

Checkout their Quickstart tutorial to get an idea of what it can do - moving in the right direction, although it's still a separate tool from vscode.

[richarddavenport]

@alohaninja awesome! Thanks for the info!

[Memphizzz]

If the extension could show this server explorer:

I wouldn't need SQL Operations Studio anymore. Is it possible to add this?

[GideonBrimleaf]

Ditto to @Memphizzz - this would really help me to adopt VS Code for SQL Sever querying!

In the mean time - any decent work-arounds?

[ek1977]

At my company we do a lot of ad-hoc data analytics using SQL server. We have been looking for an editor that supported GIT for arbitrary scripts but still allowed users to browse Server Objects. This addition would I think satisfy our requirements and likely that of many other data analytic professionals.

[guillaume86]

Not sure if this is still in consideration but the VS Code API to allow extensions to add tree-views is public now:
https://github.com/Microsoft/vscode/issues/4047#issuecomment-307303621

[jenseralmeida]

April 2018 (version 1.23) release has some new extension points which could allow a complete database experience on vscode.

https://code.visualstudio.com/updates/v1_23#_extension-authoring

[kburtram]

@jenseralmeida we would like to provide a Object Explorer experience using the new extensibility APIs. It's currently just a matter of freeing up a resource to work on this.

[Memphizzz]

@kburtram Great! I'm sure everyone in this thread is looking forward to it!

[rramname]

+1

[njonesogre]

+1

[dfruge]

+1

[dticson]

looking forward to this feature as well

[Memphizzz]

Can you share any news on this with us @kburtram?

[sneaky323]

@kburtram @kevcunnane - Is there a status update on this feature?

[Memphizzz]

btw, why is this thread still labeled as "blocked"?

[gregiare]

+1

[jamesnewsome]

This is exciting cant wait for it to be implemented!

[kburtram]

@Memphizzz I've removed the "blocked" label. Now we're just blocked on available resources. 😄

[Poltergeisen]

This is probably the only thing keeping me from using vscode full time. Any thoughts on when resources might become available?

[cyrusel]

It's not fair! Mysql extension for vs code shows objects as tree but mssql (Microsoft product) doesn't. Please add this feature.

[Andrew0002]

Also would like to see this.

[Poltergeisen]

Potential work-around for others that don't want to use SSMS. Azure Data Studio seems to be a really good alternative for most things and is built on top of vscode: https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is?view=sql-server-2017

[bobhy]

So, is that the resolution then? If you want an explorer view and intellisense SQL editing, forget about vs code and mssql extension, use Azure Data Studio instead?

[Memphizzz]

@bobhy I certainly hope not, @kburtram any plans yet or ideas on when there might be some ressources to get this implemented?

[Poltergeisen]

@bobhy I would hope not for that. The reason I didn't want to use SSMS is because I didn't want to open yet another editor to do things.

[Memphizzz]

@Poltergeisen Exactly, I dont even want to have SSMS, VSC and SQL Operations Studio installed at the same time. And as this thread has been requesting this feature for a long time and we got confirmation from @kburtram thats its doable, I'm pretty confident I will be done soon.

[immit]

This would be really be an awesome feature. Are you still planning on developing this?

[Projkt-James]

+1 for this feature

[taraansa]

+1 for this feature

[jacobchurch]

If only github would add a +1 button, hey +1 for that too! I'm helping!

[vigneshrajsb]

Waiting for this feature to have VS Code as the primary editor for sql

[Exic9999]

Adding on my +1 to keep this alive. An object explorer would complete VS Code for most of my SQL needs.

[JorisBlanken]

+1 would be great to be able to do everything from vscode

[ldnicolasmay]

+1 This would be a great feature. Thanks!

[michaeltwolfe]

+1 Really need this for what I'm currently doing lol. Thanks!

[waio1990]

+1 this would really help my current project!

[bebekim]

+1

[vtruong68]

+1 A must have for navigating large databases and tables

[Joatmon27]

+1 Very much looking forward to this one.

[MartinRiddar]

Well I'm joining the list of people who wants to see this implemented :)

[jenseralmeida]

@abist, is this feature request refused and it will not be made?

[abist]

@jenseralmeida stay tuned for updates :wink:

[gustavosmachado]

+1

[bobhy]

FYI, there is a perfectly usable VS Code-based SQL Server management tool available now, Azure Data Studio. It works great with local and Azure SQL Server (and, they say, PostgreSQL). It's obviously based on VSCode and has the same git and extensions tools.

Switching between an ADS and VSCode window (pointed at same project folder) works well for me, YMMV. But that project has probably undermined the drive for enhancing this extension and seems to be the closest we'll come to full feature SQL editing and DB admin in this lifetime.

[JorisBlanken]

FYI, there is a perfectly usable VS Code-based SQL Server management tool available now, Azure Data Studio. It works great with local and Azure SQL Server (and, they say, PostgreSQL). It's obviously based on VSCode and has the same git and extensions tools.

Switching between an ADS and VSCode window (pointed at same project folder) works well for me, YMMV. But that project has probably undermined the drive for enhancing this extension and seems to be the closest we'll come to full feature SQL editing and DB admin in this lifetime.

A good management tool, but no better than SQL Server Management Studio for me.
I suspect that the point for most of us is to get away from having to use multiple programs.

[abist]

The new version is with the Object Explorer feature is out!

[testingcan]

Thanks for all your work, this is such a major improvement!