Aliases - also enclose with square brackets []
using the example
SELECT patientid FROM PTGEPATIENT AS pgp
If I qualify object names (ctrl-B, ctrl-Q), I will get
SELECT [pgp].[patientid] FROM [dbo].[PTGEPATIENT] AS pgp
The alias is not enclosed in square brackets after the "AS" keyword. Would like to see that support for consistency (this is the standard I currently have in place)
7
votes
hfxDBA
shared this idea
This is included in SQL Prompt 6.4, which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/