SQL Prompt - script object as ALTER

In this tip Data Platform MVP Steve Jones explains how to use SQL Prompt to script out objects as an ALTER statement in just a couple of clicks.

Transcript:
Hi I'm Steve Jones from SQL Server Central and I've got another quick SQL Prompt tip brought to you by Redgate Software. One of the things people love about SQL Prompt is that I can type things like this store procedure and I'll get information about it and if I actually highlight at the end of it I can click on this and I can see the code. But that's sometimes hard to read and I have to expand this out to look at the rest of the code.

If I want a quick look at what's inside of this I can right-click it and select Script object as ALTER. When I do that I’ll get a new window with all the code for the stored procedure listed including the alter procedure already set up, so if I need to change some code - perhaps I wanted to actually change this - then I could actually do that and compile it very quickly. Or if I just want to look at the code I can see it and then when I'm ready, go back to my original query. Hopefully this quick tip is something you'll use in SQL Prompt. I'm Steve Jones for SQL Server Central and Redgate Software.

[Tanner_o]

Please add USE database at the beggining as SQL Management do when Modify.