Skip to content

How can we improve SQL Prompt?

SQL Prompt: Format SQL

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

Column aliases alignment

Allow alignment of column aliases in a Select statement.

22 votes

Brad shared this idea · May 31, 2011 · Report… · Admin →

completed ·

Andrei Rusitoru responded · May 25, 2017

This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes

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

Thank you for your help!

Show previous admin responses (2)

An error occurred while saving the comment

Kurt Kiley commented · March 14, 2017 2:15 PM · Report

Block alignment of column aliases would be a huge time saver.

Submitting...
Emil Vissing commented · February 20, 2017 2:04 AM · Report

Any news on this one?

Submitting...
AdminAaron Law (Admin, Redgate) commented · July 21, 2016 4:04 AM · Report

Hi Matt,

At the moment the new system aligns the first type of aliases but not the = style. We'll look into aligning that style too for the upcoming beta. Thanks for your feedback!

Submitting...
Matt Bolton commented · July 21, 2016 3:57 AM · Report

Great to see this as planned.

Will it include alignment in both uses of an alias?

SELECT Col1 as A (where A (or AS) should be aligned, and,
SELECT A = Col1 (where = should be aligned)

Submitting...