Add a "Script ... As" option to SSMS?

  • 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. 😎

  • 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:

    [/url]

  • +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