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. Ability to delete based on filter in tab history

    I love the Tab Magic tool, but I'm finding that it is saving a lot of old tabs where I had to provide a password to a script. For security purposes, I need to clear these out on a regular basis, so I don't have a secure account compromised.

    It would be nice to have the ability to filter bases on a phrase (such as Password) and then delete only those tabs. That way, I can keep the rest while still being secure

    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  ·  SQL Tab Magic  ·  Flag idea as inappropriate…  ·  Admin →
    • Qualify Ojects in SQL (Add square brackets)

      When formatting SQL, add an option to force all possible columns/objects/whatever to be qualified with square brackets. So:

      CREATE TABLE #qqqqq (aaaaa INT,bbbbb INT,ccccc VARCHAR(5));
      Becomes: CREATE TABLE [#qqqqq] ([aaaaa] INT,[bbbbb] INT,[ccccc] VARCHAR(5));
      Or: CREATE TABLE [#qqqqq] ([aaaaa] [INT],[bbbbb] [INT],[ccccc] [VARCHAR](5));

      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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
      • SELECT indenting option suggestion

        SELECT indenting option suggestion

        Sample query (spaces marked with underscores):

        SELECT__staffId, staffName, a
        FROM____personnel

        SELECT and FROM have 2 whitespaces (based on the longest keyword here is SELECT) after them to align the rest of the statement. There is no reason to use 2 space here. Please add an option to set this to 1 space like below sample.

        SELECT_staffId, staffName, a
        FROM___personnel

        Just one space (after the longest keyword).

        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 →
        • Keep selection when closing the "Summarize Script" window

          The "Summarize Script" feature is great and helped me many times to navigate large scripts. I like especially the fact that the code is highlighted when I click on different parts of the summary. Unfortunately, the selection vanishes the minute I close the summary window. I don’t know why that is.

          Of course the new feature of highlighting matching BEGIN … END helps me find the beginning. Yet, I don’t see the reason why the selection is not longer available after closing the summary window.

          Furthermore, I would like to suggest that – in the summary window – you allow…

          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  ·  Summarize Script  ·  Flag idea as inappropriate…  ·  Admin →
          • Include MERGE statement in smart rename

            When one would like to smart rename a column, the smart rename function does not update a MERGE statement. Could this be added to the smart rename feature?

            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…)
              0 comments  ·  Smart Rename  ·  Flag idea as inappropriate…  ·  Admin →
            • Allow Alias Names to Conflict with Stored Procedure Names

              We have a table called SalesOrder. We also have stored procedures named so, so2, and so3. When SQL prompt creates the auto alias, it uses so4 because it won't create an alias using the name of an existing object.

              I would like the alias to use so. The aliases don't need to have unique names in cases where the name conflicts with the name of a stored procedure.

              If that's not possible or likely, then I would like SQL Prompt to use the custom alias defined for the table, even in cases where the name conflicts with a stored procedure.

              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 →
              • derived table and subquery indent

                i don't like the derived table and subquery indented to the position of the opening paranthesis. for me they should only be indented once:

                SET @intSomeLongVariable = (
                [TAB]SELECT
                ...

                instead of

                SET @intSomeLongVariable = (
                [TAB][TAB][TAB][TAB][TAB][TAB]SELECT
                ...

                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 →
                • qualify column names with table: temporary tables

                  The qualify column names should work with temporary tables as well.

                  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…)
                    1 comment  ·  Qualify Object Names  ·  Flag idea as inappropriate…  ·  Admin →
                  • Add an option to position SQL Prompt popup at a screen edge, rather than at the cursor position.

                    What is near the cursor tends to be data that should not be covered over. I need to see it in order to complete my statement.

                    4 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 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

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

                              6 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

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

                                    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…)
                                      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.

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

                                        4 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 →
                                          ← Previous 1 3 4 5 18 19
                                          • Don't see your idea?

                                          Feedback and Knowledge Base