Scripting an object as ALTER
Published 11 February 2013
You can use SQL Prompt to script out an object in a query:
- In a query window, right-click the object you want to script out:
- 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)