Qualify column names with table aliases only
I would like an additional option for the Inserted code > Qualification tab:
Qualify column names with table aliases only.
Most times I want to assign a table alias and use it when adding columns, however if I forget to assign a table alias or remove it, I don't want a fully qualified table name when using the Qualify column names with table name option.
I would like the option to qualify with both table names and table aliases or just table aliases and NOT table names.
16
votes
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Phil Helmer
commented
This is particularly annoying when writing single-table delete statements without using table aliases.