It's a pretty common thing to right-click on a stored procedure, function, or view to look at the source code. Understand that I'm specifically limiting the scope to looking at the T-SQL code, not changing it. You have the option to script the procedure, function, or view as either a CREATE script or an ALTER script. If you use ALTER, you're at risk of accidentally changing the code. If you use CREATE and you do hit F5 or execute, you'll get an error message stating that the procedure, function, or view already exists. Your code won't be changed.
