These pages cover SQL Prompt 9, which is not the latest version. Help for other versions is also available.
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.
Supported objects
SQL Prompt can script out:
- views
- stored procedures
- triggers
- functions (scalar-valued and table-valued)