Skip to content

How can we improve SQL Prompt?

SQL Prompt: Find invalid objects

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

Highlight the invalid objects within the Alter script(s)

Highlight the invalid objects within the Alter script(s)

7 votes

Larry Meklemburg shared this idea · May 17, 2011 · Report… · Admin →

completed ·

Aaron Law responded · Aug 20, 2015

This is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/

Show previous admin responses (1)

An error occurred while saving the comment

kevriley commented · July 20, 2015 7:00 AM · Report

In v6.6.0.204 The highlighting is directly on target when the invalid object is a column, but if it's a table/view the the first line of the statement is highlighted, and often the actual object is several lines down - could this be tweaked to highlight the object?

Submitting...
Larry Meklemburg commented · May 17, 2011 10:46 AM · Report

Otherwise you need to search for it when the alter script is picked.

Submitting...