SQL Prompt 6

Scripting an object as ALTER

You can use SQL Prompt to script out an object in a query:

  1. In a query window, right-click the object you want to script out:
  2. On the context menu, click Script Object as ALTER.
    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 F12.

Supported objects

SQL Prompt can script out:

  • views
  • stored procedures
  • triggers
  • functions (scalar-valued and table-valued)

Didn't find what you were looking for?