Scripting an object as ALTER
Published 11 February 2013
If you are navigating a query that contains a reference to an object, SQL Prompt enables you to script out that object directly from the query window.
You can script out the following objects:
Views
Stored Procedures
Triggers
Functions (scalar-valued and table-valued)
To script out an object from a query window:
- In the query, 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.
Keyboard shortcut: with the mouse insertion point on the name of the object you want to script out, press F12.