Options -> Settings -> Qualify column name -> **enclose with []
It would be a nice feature if you can add to database, schema and table brackets []. If you use certain characters like $ you have to enclose it with [].
Ted Dean
shared this idea
It’s implemented in the latest build of SQL Complete. Have a look at the “Enclose identifiers within square brackets” option.
-
frederico
commented
sadly only option was to add the brackets, not to remove them.
-
Anonymous
commented
I agree with frederico. The omission of a feature to automatically insert or remove brackets is a serious omission in my opinion. In my current environment they are required so features like adding multiple column name from the list is useless because I would have to waste the time I saved going back to add the brackets.
-
Bill Hatter
commented
I enclose all my identifiers in []. Was sad to see all the available options in text case, but nothing for enclosing column names, tables, or schemas in brackets.
-
frederico
commented
Just to satisfy everyone it would be great if the option was to REMOVE all or to ADD all in both object references and column references.
some companies have as a standard that brackets are NEVER to be used, others like them to always be there
And then there are the situations where we are forced to use them (e.g. "on primary" keyword on table/index creation)
-
AdminDevart
(_, Devart)
commented
Actually, we enclose identifiers with square brackets if the contain illegal symbols. But '$' symbol is the legal one.