Idea: Implementing TreeView / Quick Search ?

[datauduong]

• MSSQL Extension Version: 1.2.1
• VSCode Version: 1.18 x64
• OS Version: Windows 10 Pro x64

Sample of Tree View like - GitLens
Showing SQL Database/Objects (Table, View, Store Procedure ...)
Very handy so that, Simple SQL Task can be perform without leaving the editor and switch to ssms tool.

Example:
+-------------------------------------------+
| Type in Object Name for Quick Search |
+-------------------------------------------+
| Tree View of Objects |
| Database |
| Object Name | Type |
| MyTable | Table |
+-------------------------------------------+

[datauduong]

Is this the answer to my question?
https://blogs.technet.microsoft.com/dataplatforminsider/2017/11/15/announcing-sql-operations-studio-for-preview/

Very Sleek UI, It look very much like Visual Studio Code, but targeted to SQL Server.

It would be interesting to see if this can merge into Visual Studio Code
"One Tool"

[MattIrv]

Thanks for the suggestion. I'm glad you found SQL Ops Studio (https://github.com/Microsoft/sqlopsstudio on GitHub), but I'll also leave this open as well. The way that GitLens shows tree-style information is pretty neat, so thanks for pointing it out!

[mika76]

I second this request - even just as a lookup to columns, tables, stored procs. Currently I have to either write whole query to just look something up or have to open SSMS on a windows machine. (haven't tried ops studio yet)

One other thing - please make the search work without the dbo. prefix (it's the most irritating thing in SSMS object explorer)

[abist]

Closing this as it's being tracked here - #586