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.
This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved
