SQL Prompt

Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.

If you have any questions, need help or have found a bug in SQL Prompt, please visit the forums at http://www.red-gate.com/messageboard/viewforum.php?f=169.

How can we improve SQL Prompt?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  1. Add connection limit for restoring tabs

    Please add an option to ignore tabs over a certain number of connections.

    It would avoid long waits when SSMS starts if in the previous session I forget to close a one-time query against hundreds of servers.

    In its current implementation, SQL Prompt can crash SSMS before the connections complete.

    See SQL Prompt forum for context:
    http://www.red-gate.com/MessageBoard/viewtopic.php?p=71834

    5 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  SQL Tab Magic  ·  Flag idea as inappropriate…  ·  Admin →
    • Suggest ON clauses based on mutual foreign key constraints

      Suppose we have three tables A, B and C. Both B and C have differently named foreign keys to primary key table A:

      B.mID -> A.ID
      C.aID -> A.ID

      Now I'd like to do this:

      SELECT * FROM [B] INNER JOIN [C] ON [B].[mID] = [C].[aID]

      Problem is, that intellisense doesn't recognize the shared foreign keys of table B and C to A, so it won't give me the clause as an ON clause suggestion. But that would be a tremendous help in our current project.

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
      • Ability to create report

        Need the ability to create a report form find invalid objects. Something like the reports created in SQLCompare would be ideal

        3 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Find Invalid Objects  ·  Flag idea as inappropriate…  ·  Admin →
        • Bug: Identifies strings as invalid column name

          The following code snippet throws an invalid Column Name 'D' in a stored procedure that has QUOTED_IDENTIFIERS set to OFF

          ... IF @Status = "D" ...

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Find Invalid Objects  ·  Flag idea as inappropriate…  ·  Admin →
          • Format SQL with Obfuscation (Columns/Tables)

            Because most custom code is proprietary, It would be nice to have an obfuscation or masking feature. If you were able to replace all of the columns and tables referenced with a generic name, keeping the references, it would be quick and simple to share. I'm thinking like SQL Sentry's Plan Explorer where you can obfuscate the execution plan. This would be helpful so that you can quickly share code examples, without breaking a copyright.

            5 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
            • Retrieve BETA Updates when checking for updates

              I usually run the latest version of the beta and it would be nice if "Check for Updates" would pick up the latest version version of SQL Prompt, including any beta versions.
              Perhaps this could be an option for those that aren't interested in participating in betas.

              3 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                2 comments  ·  Flag idea as inappropriate…  ·  Admin →

                The way it should work at the moment is if you have a beta build installed then you’ll get stable and beta builds on check for updates, which look something like:
                https://i.imgur.com/f0a1o8N.png

                If you have a stable build Prompt installed however you’ll only get new stable builds listed. So by installing a beta you’ll be opting into new beta builds, does this sound ok?

                (…and I just noticed we hadn’t added the latest few updates to CFU, I’ll make sure all the new ones are on there!)

              • Remove trailing spaces

                Option to remove trailing spaces from script lines. This can be done via search/replace functionality but it would be nice to have this taken care of automatically during the SQL code reformatting

                2 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                • Find unused columns in SELECT statements

                  Find unused columns in SELECT statements similar to finding unused variables.
                  Use case: I have some subqueries where I expanded SELECT * to now explicitly specify column names (best practice). However, only some of the columns and then used in the query process or results. I thus want the ability to have the unused columns removed from the SELECT statement.

                  1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Find Unused Variables  ·  Flag idea as inappropriate…  ·  Admin →
                  • On-Demand only option for suggestions, using a keyboard shorcut

                    Sometimes the suggestions can get in the way (annoying popups) when you do not need it.

                    I would be more productive with an On-Demand Only option (using a keyboard shortcut) to:
                    1- Display code suggestions
                    2- Display object definitions
                    3- Tooltips for objects and parameters

                    The way it works now for #2 and #3, is all or nothing (enable/disable).

                    We have a timeout option for #1, so we can accomplish a similar result by using a very high value (like 60 seconds) and using Ctrl-Enter when needed.

                    3 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                    • Find missing Foreign Key or data integrity issues

                      So right now I have the ability to find dependent objects when I try and rename a column. I am using this feature in a very poorly managed database in order to work out what tables link to what and potentially what Foreign Keys I need to add to the database.

                      3 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • Creating relation mappings for databases that may not be changed

                        In our company we are working with SAP Business One (SBO). SBO has a fixed database stucture which may not be changed at all. Relations are not directly built into the database.

                        A custom relation mapping feature would help us with correct suggestions for the databases while still maintaining the database structure as it is.

                        12 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          2 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                        • Autogen insert and commas at the beginning of the statement

                          I find having the commas at the beginning of the line extremely useful - and was glad that Sql Prompt allows us to set the default as such for insert statements. I have to say the format is quite difficult to read, and find that I have to rewrite it each time. Can you please spend a few minutes to clean it up? I see there are a couple outstanding requests that have been ignored for 2 years now - no input from redgate at all. I'm sure there are others who would agree with this - (just check out…

                          3 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Give Format SQL the ability to convert X.Field1 AS NewFieldName format to FieldName = X.Field1

                            We have a lot of legacy code that is written as

                            SELECT Field1 as Name1, Field2 Name2 FROM Table X
                            (Sometimes they use AS when setting the alias, othertimes they do not).

                            I would love the ability to convert this to
                            SELECT
                            Name1 = X.Field1
                            , Name2 = X.Field2
                            FROM Table X

                            Both having the ability to switch between Name = Value and Value AS Name and to auto add the alias to all fields.

                            7 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                            • Add ability to share code or highlighted snippet as email (or optionally as an attached file)

                              I share a lot of code and there's no easy way to email a script or highlighted SQL code from within SSMS. I'd love to be able to highlight text and hit a hotkey that would copy the text into a new email message, or alternatively hit a button which would create a new email with the script I'm working with attached as a file.

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • 1 vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                • Function "Select In Object browser" should support that the tree list is filtered

                                  We have a large number of tables and stored procedures so I often use the filter feature in SSMS to reduce the tree size in object browser. When I then try to use "Select In Object browser) with CTRL+F12 and the object isn't available in the tree (cause of the filter); the select function fails. SqlPrompt often expands the System tables/proc node instead.

                                  Maybe the filter can be cleared or a messagebox with a Yes or No question can be displayed.

                                  2 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Dot insertion key breaks IP addresses in Linked Servers

                                    I added the 'dot' option to insertion keys and now I am unable to type dots in an IP address for a linked server without it autocompleting some random address, which I then have to go back and correct.

                                    3 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Add the ability to exclude databases from suggestions

                                      . Currently we can only specify databases to include for suggestions. It would be great to be able to specify databases to exclude as well.

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Indent Guides Line

                                        Sometime, my sql query script have too much nested condition and I need to see the indent guides line like this image:
                                        https://lh4.googleusercontent.com/-qmpRo6zwZTo/U6EzoIkdw7I/AAAAAAAAAYs/ctAXWq5nPwc/w725-h316-no/Untitled.png
                                        It would be awesome if you include this feature in this product.

                                        18 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Format SQL Code on opening file

                                          It would be awsome if there was an option that would format an SQL Script automatically after opening it in SSMS / VS. So if you load a file it would be formatted automatically with your selected formatting style. It would be great too if this auto format option could be switched on and off in the Options.

                                          9 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 17 18
                                          • Don't see your idea?

                                          Feedback and Knowledge Base