Scripting an object as ALTER

You can use SQL Refactor Studio to script out an object in a query editor:

1. In a query window, right-click the object you want to script out:

   

2. On the context menu, click Script object.

   The object is scripted as an ALTER statement in a new query window.

Alternatively, place the cursor over the name of the object you want to script out and press F2.

Supported objects

SQL Refactor Studio can script out:

• Stored procedures
• Views
• Functions
• Tables
• Triggers