March 16, 2015 at 10:47 am
Hi,
So, you know how if you right-click, say, a table object, in SSMS, and one of the options is, "Script Table As" and then you get a bunch of options (some of which are greyed out - why do they do that? If an option doesn't apply to that particular object, why not just have it not appear and clutter up the list?)
Is there any way to add an option to that list? Say, for tables, add an option to "ALTER ADD COLUMN To"? Just to make life a lot easier. 😎
March 18, 2015 at 4:20 am
Katerine459 (3/16/2015)
Hi,So, you know how if you right-click, say, a table object, in SSMS, and one of the options is, "Script Table As" and then you get a bunch of options (some of which are greyed out - why do they do that? If an option doesn't apply to that particular object, why not just have it not appear and clutter up the list?)
I think that's a standard "Windows" way of presenting menu options, not necessarily
exclusive to SSMS.
Is there any way to add an option to that list? Say, for tables, add an option to "ALTER ADD COLUMN To"? Just to make life a lot easier. 😎
There is a way provided to extend the "Tools" Menu options in SSMS from the Tools... External Tools option, for instance, you can add external programs you might want to fire up from within SSMS, but I don't believe you can extend the context menus you are speaking of without resorting to some kind of coding that creates an "AddIn".
If you are that way inclined you can get yourself started with this:
March 18, 2015 at 4:42 am
+1 If you want extra functionality in SSMS, you need to create an add-in, or install a 3rd party add-in that achieves your requirement.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply