SA 12 Feature Request using "Copy to editor" func

When using the code "hyperlink" when hovering over a stored proc; you get the stored proc in a tabbed window below. Using the "copy to editor" function is great to pull this into the editor.

However:
"CREATE PROCEDURE [bar]" is still in the code at the top. Can we somehow programmatically change this to "ALTER PROCEDURE" or if the SQL Server version is above 2016 SP1 "CREATE OR ALTER PROCEDURE"?

Often times I forget to change this myself and get an error executing the code or worse yet miss the error and try and use the front end with the new procedure code and not get the expected result...

both of these mostly because I'm an idiot.

That method is more suited for code preview. But if you click the name-hyperlink in the top left corner, it will open the properties dialog where code can be edited and that dialog provides for some types of of procedural objects Open in Editor button to open the code for editing in an editor tab.

Brilliant.... so obvious I missed it.

Like I said, I'm an idiot.

If this is the Code "hyperlink" you're referring to,

there should be another one next to it named Edit, which should open a brand new tab for editing that particular stored procedure with ALTER (or DROP and CREATE where ALTER is insufficient).

Check this short video here.

	gemisigo wrote:
	If this is the Code "hyperlink" you're referring to, there should be another one next to it named Edit, which should open a brand new tab for editing that particular stored procedure with ALTER (or DROP and CREATE where ALTER is insufficient). Check this short video here.

Yes that works too. I'm banging my head against the wall now.