patternsqlMajor
SQL Server 2012 is putting [brackets] around Table and Column Names
Viewed 0 times
around2012columnsqlandbracketsnamesputtingservertable
Problem
When you drag the Columns folder to editor Window, the full list of Columns are added without Brackets. If you drag columns individually they have Brackets.
Is there anyway to turn that off? I'm unable to find anything in options, and they're really a distraction.
Is there anyway to turn that off? I'm unable to find anything in options, and they're really a distraction.
Solution
There isn't a way to prevent this. Microsoft feels that it is better to prevent you from shooting yourself in the foot, probably since the number of people out there who create databases, objects or columns with bad names (e.g.
There was a Connect item asking for this option, and it was very quickly dismissed and closed as "Won't Fix." And in fact many more users were asking that square brackets be added to places where they previously didn't work.
my table or date) or reserved keywords (e.g. log or timestamp) outnumber those who never do so.There was a Connect item asking for this option, and it was very quickly dismissed and closed as "Won't Fix." And in fact many more users were asking that square brackets be added to places where they previously didn't work.
Context
StackExchange Database Administrators Q#21779, answer score: 21
Revisions (0)
No revisions yet.