Remove square brackets
Microsoft's SQL Server Management Studio puts square brackets [ and ] around everything scripted or dragged/dropped from the Object Explorer to the scripting window.
I want a feature to remove all square brackets.
I currently have to use SQL Management Studio search/replace to remove the brackets, and rather have the removal performed when I format the code.
Removing brackets when they are not required would be great. The regular expression comment gets part of the way there, but SQL Complete could strip them when not needed and that would be useful.
Dmitrij Kultasev commented
Removing brackets is a good idea. SQL Prompt made good functionality when reserved are wrapped into brackets automatically.
do a search replace with regular expressions:
Removing square brackets is not a good idea. Code with tables that have names - reserved words will have issues, for e.g. SELECT * FROM dbo.Group fails with an incorrect syntax.