question

Per S avatar image
Per S asked

Where did "Modify" (aka "Edit") for views go? Gone in SQL Server 2008 Management Studio?!

Right-clicking a view in SQL Management Server Object Explorer no longer offer a "Modify" (aka "Edit") menu item, only "Design". To alter a view one have to select "Script view as", "Alter to", "New Query Edit Window". Its rather tiresome. Is there any way I can bring back the standard "Modify" and go from painstakingly slow three mouse-clicks to one? Or is there any other shortcut? Any ideas welcome!
sql-server-2008-r2ssmsviewvisual-studio-2008
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

bonskijr avatar image bonskijr commented ·
I have the Modify menu option when right clicking a stored proc.
0 Likes 0 ·
Per S avatar image Per S commented ·
Yes, its only the view that seem to have lost it. Functions and procedures are intact.
0 Likes 0 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
I have to ask, how many of those two extra mouse clicks could you have performed in the time you were answering this question? It does make me smile - people complain about all sort ('why has this moved', 'why is the shortcut key different') - but sometimes it's more about making fragmented worlds come together (e.g. shortcut similarity between visual studio and ssms) than it is about keeping history...
0 Likes 0 ·

4 Answers

·
Fatherjack avatar image
Fatherjack answered
I dont know of one so it looks like you may have to keep on with those 2 extra clicks, unless you abandon the mouse and simply do everything in the TSQL editor ...?
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Per S avatar image Per S commented ·
Or even better, from the command prompt! ;)
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered
There is an active item on [Connect][1] about this [1]: http://connect.microsoft.com/SQLServer/feedback/details/362679/ssms-right-click-on-a-view-to-edit
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Per S avatar image Per S commented ·
Thanks for the information. So there is no option or registry tweak for this apparently. What happened to "if it works don't fix it"= ;)
0 Likes 0 ·
Leo avatar image
Leo answered
You can still select DESIGN and change what you want... That might be the same as Modify in VIEW.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
Whilst that does give you the ability to make changes - it's not quite the same. That is the Query Designer, not a Query Window - so things like intellisense, templates etc, etc aren't available
0 Likes 0 ·
Per S avatar image Per S commented ·
Have to agree with Kev, these are two very different ways of editing a view, both of them good but in different ways and in different situations. Design is not a replacement but a good complement.
0 Likes 0 ·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
Yeah, it's missing and the only current way is tu use Script View As -> Alter To -> New Edito Window. It is possible to add it back by writing a small custom plugin which will script the view to new query window. :-)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.