Click here to Skip to main content
15,944,828 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I am trying to create an extension for the tables in any database which will be shown when I right click on any tables in SSMS, I want to run that extension from there. Furthermore, I want my extension to make insert queries, delete queries or any other queries on their own when user clicks on any table (as of now to make it simple lets say it just only prints a message "hello world!"). Please help with the same for any reference or from where and how to start approaching this kind of thing.

I took reference from this link creating-visual-studio-extensions-for-table-nodes-in-the-server-explorer-data-co[^]

here I have checked and replicated the .vsct file like this:scrennshot-vsct-file

from what I have seen from this it's kind of an structure so to how to display the extension command.

What I have tried:

what I have done till now: I took reference from the below links to first create an extension in SSMS tools bar using visual studio (VSIX project) and replicated the same as mentioned in the first link provided below:

link1
link2
link3

Also i have figured out how to find the GUID and GUID-ID when i press CLTR+SHIFT+Right click.
So now as this is done I am unable to understand how to approach the work I want to do as I mentioned above, since till now my extension is only visible in the tools menu which i don't want now i want it to be shown when I right click on any of my tables in the database. I know from the GUID i need to do something , but how that's the question and wanted to learn more about the structure of the above .vsct file. Also if i change the GUID and Ids as mentioned , how am i supposed to hit my method/action in the command file. Please help me understand this.
Posted
Updated 19-Feb-24 5:47am
v2
Comments
Maciej Los 19-Feb-24 13:48pm    
Member 16202340 19-Feb-24 22:55pm    
Hey,
I have already done that , please check the part what i have tried , there i have mentioned that the basic needs of simple message that needs to be shown in the extension is already done as per the links i shared , but now i wanted to do more deep dive in , since that was only visible in the tools part of the SSMS , but i need it to be shown when i right click on any Table in the SSMS.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900