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