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.
SQL Prompt can script out:
- stored procedures
- functions (scalar-valued and table-valued)