Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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.

Jake

73 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Jake shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    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  ·   ·  Report

    Removing brackets is a good idea. SQL Prompt made good functionality when reserved are wrapped into brackets automatically.

  • Martin commented  ·   ·  Report

    do a search replace with regular expressions:
    search: \[([a-zæøå]\w*)\]
    replace: $1

  • Anonymous commented  ·   ·  Report

    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.