Skip to content

How can we improve SQL Prompt?

SQL Prompt: Script object as alter

CATEGORIES
All ideas
My feedback
Code Analysis 48 ideas
Encapsulate as new stored procedure 1 idea
Expand wildcards 7 ideas
Find invalid objects 7 ideas
Find unused variables 3 ideas
Format SQL 187 ideas
Intellisense 77 ideas
Platform Support 16 ideas
Qualify object names 6 ideas
Script object as alter 14 ideas
Smart rename 10 ideas
Summarize script 5 ideas
Tab coloring 5 ideas
Tab history 42 ideas
User interface 88 ideas

Searching…

No results.
Clear search results

- Flyway 15 ideas
- MySQL tools 24 ideas
- Oracle 129 ideas
- Redgate 0 ideas
- SQL Change Automation 50 ideas
- SQL Compare 249 ideas
- SQL Data Compare 110 ideas
- SQL Prompt 663 ideas
- SQL Search 133 ideas
- SQL Source Control 588 ideas
- SQL Toolbelt Essentials 16 ideas
Redgate

Script object as alter not enabled for table-valued functions and views.

3 votes

meyerovb shared this idea · Mar 8, 2011 · Report… · Admin →

completed ·

Thomas Walsh responded · Sep 19, 2018

We’ve released support for this in SQL Prompt.

You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.

Here’s the updated documentation for the Script as ALTER feature: https://documentation.red-gate.com/sp9/navigating-your-code/scripting-an-object-as-alter

If there is something missing please let us know by opening a new suggestion.

Kind regards,

The Prompt Team

An error occurred while saving the comment

Kevin Greiner commented · February 14, 2012 8:48 AM · Report

Appears to be implemented now. I just used "script object as alter" a few minutes ago for both views and table valued functions.

Submitting...