SQL Prompt 9

These pages cover SQL Prompt 9, which is not the latest version. Help for other versions is also available.

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?