Add brackets to all database objects
Similar to the existing Qualify Object Names and the other pending request to fix case of all object names, I would like to have an option to add brackets added to all database object names (columns, tables, schemas) where they are missing.
This is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
Agree with Dave and Daniel. It's obviously either the reader's preference of perhaps a site standard but my choice, for readability, is no brackets beyond those absolutely necessary. Option, please.
Dave Slinn commented
Removing brackets would also be a useful option for this feature. Our database has several tables named the same as SQL keywords (Option, Plan and Order to name a few) so we have established a corporate coding standard to use brackets. Most developers in our company have enabled the option in Red Gate SQL Prompt to auto qualify objects with surrounding brackets but it would be nice to be able to apply to any SQL we encounter, including old stored procedures in our application and any scripts written by those non-compliant developers.
Daniel White commented
I would prefer to be able to remove all brackets that are not needed.
Michael Dean commented
This would be very useful to have. Without the brackets, some of our column names appear in blue - indicating a reserved word. The column was "CONTACT" - which may have been a combination of first_name and last_name.
If implemented, it would be helpful to state which objects get brackets. For me, table names look odd with brackets, but I really like them on column names.