Qualify Ojects in SQL (Add square brackets)
When formatting SQL, add an option to force all possible columns/objects/whatever to be qualified with square brackets. So:
CREATE TABLE #qqqqq (aaaaa INT,bbbbb INT,ccccc VARCHAR(5));
Becomes: CREATE TABLE [#qqqqq] ([aaaaa] INT,[bbbbb] INT,[ccccc] VARCHAR(5));
Or: CREATE TABLE [#qqqqq] ([aaaaa] [INT],[bbbbb] [INT],[ccccc] [VARCHAR](5));
Brad Simpson
shared this idea
This is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
-
Paul Shearing
commented
Yes I agree. I much prefer the look of code with square brackets around database, schema, table and field names, even where such are not required (i.e. white-space in the names). I think it significantly aids readability. Such a feature would save me typing time and ensure consistency in my SQL coding.
-
Phil
commented
It would also be helpful to have an option to add square brackets only for reserved word or a list of names that can be managed by the user.