What are the challenges you face when working across database platforms? Take the survey

Script as Alter

rldawgrldawg Posts: 35 Bronze 3
edited September 7, 2010 5:53AM in SQL Prompt Previous Versions
This is a fantastic feature. It will come in handy for sure.

Here is a suggestion along those lines. On the context menu for a View in the object explorer, it would be totally awesome if you could add an Edit option that creates an alter script. IN SSMS 2005 there was a context menu option to Edit a view. Microsoft inexplicably removed the option in SSMS 2008 and has refused to put it back. Instead, from the context menu we must select Script View AS > Alter to > New Query Window. It would be nice to bring back the one step vs 3 steps.

Hopefully you guys see this as worthwile. Perhaps others in the forum agree?

Thanks for a great product!


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Many thanks for your e-mail.

    We appreciate your feedback and hence logged this as a feature request in our internal tracking system whose tracking id is SP-3407.

    It will be reviewed by product manager and than marked for the next release.

    I will update you as soon as it is incorporated.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.