SQL Server management studio add-on

I would like to extend SQL Server Management Studio with the "Code explorer" the functionality. I would need new docking windows (like object exploere or boomarks) which would enabled me to see line numbers where CREATE and/or ALTER (check box option) table/view/procedure/function/trigger is used in a tree like structure. When I would double click an tree item it would focus me to that line in the file/script. Tree can be generated on click.

-

|

|- Tables

|-- 1 - create Table1

|-- 3 - create Table2

|

|- functions

|-- 5 - create function 1

|-- 7 - create Table2

|

|- procedures

|-- 9 - create procedure

|-- xxx - alter procedure

..

What is described above can be also achived by extending functionality of bookmarks, where I only need a button that would auto create the bookmarks from the active script (and delete existing bookmarks from the same file - if some check box would be selected)

Problem is that I use scripts for creating SQL structures that are 1000+ lines of code long and it would be great if I could find quickly the right line of code (also in the right "sql" file if I have many files open at the same time).

视窗桌面

项目ID： #9035677

关于项目