Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete: Features

Categories

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

75 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 →

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
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Hello,

    We’re excited to share that the functionality you requested has been successfully implemented!

    Please update to the latest release version to start using the new features. If you have any further questions or need assistance, feel free to reach out to us.

    Best,
    Devart Team

  • 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.