Vscode-mssql: Open database objects

[casraysa]

Hi,

First of all, thank you for this superb Visual Studio Code extension. I'm writing just to make a suggestion. I'm writing just to make a suggestion. I would be nice to have the Open option when you do right-click onto one of the database objects (as stored procedures, functions, etc.)

Kind Regards.

[abist]

@casraysa Thanks for opening this issue! When you say Open database objects, what exactly do you mean? Just trying to get more details on what you want to see.

[casraysa]

In the database explorer, I want to have an option to open and see or modify the code of a user-defined function or the code of stored procedure that is kept in the database. It would be great if you could have similiar functionalities to the SQL server object Explorer.

[abist]

@casraysa Do you mean adding scripting methods to create/drop/alter/execute objects?

[casraysa]

Right now, you can select a table or view and see their records. I would like to have the option to open the code that generates a view or the code of a stored procedure as you can do in SSMS object explorer.

[testingcan]

This is probably addressed with #1474, right? Though there is no Modify function, CREATE and ALTER are available and working.

[casraysa]

Hi,

That is awesome!! Thank you very much.

Kind regards,
Salva

Obtener Outlook para Androidhttps://aka.ms/ghei36

---

From: testingcan [e-mail]
Sent: Friday, January 17, 2020 11:42:45 AM
To: microsoft/vscode-mssql [e-mail]
Cc: casraysa [e-mail]; Mention [e-mail]
Subject: Re: [microsoft/vscode-mssql] Open database objects (#1509)

This is probably addressed with #1474https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fvscode-mssql%2Fpull%2F1474&data=02%7C01%7C%7C214d6db37a7c404e814508d79b39fcf5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637148545661861421&sdata=ldj1TqneGYDlftZUE33%2BJdPlXX9eJKQoO70xcds5ZFw%3D&reserved=0, right? Though there is no Modify function, CREATE and ALTER are available and working.

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHubhttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fvscode-mssql%2Fissues%2F1509%3Femail_source%3Dnotifications%26email_token%3DADNHBQBLMS3LYEP324RDTQLQ6GDSLA5CNFSM4JQTGSVKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEJHI44Q%23issuecomment-575573618&data=02%7C01%7C%7C214d6db37a7c404e814508d79b39fcf5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637148545661871420&sdata=b5swotCjq3Ga2kfCB1FVhSNt%2BCB1AySTGHoaDkmJANM%3D&reserved=0, or unsubscribehttps://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FADNHBQECIKXFTSTRQVE247LQ6GDSLANCNFSM4JQTGSVA&data=02%7C01%7C%7C214d6db37a7c404e814508d79b39fcf5%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637148545661881431&sdata=4xFY70%2FcSuzPDmXybgXvF0g6uHKucpHQcEUxE0V6Pm8%3D&reserved=0.

[abist]

@testingcan Yes, you're right. Currently, we only support CREATE, DELETE, ALTER right now. Feel free to open another issue for the Modify option.