SQL Prompt 5

Scripting an object as ALTER

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:

  1. In the query, 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.
Keyboard shortcut: with the mouse insertion point on the name of the object you want to script out, press F12.

Didn't find what you were looking for?