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 https://forum.red-gate.com/categories/sql-prompt

Update (Jan 2019):
To help with internal prioritisation, suggestions with no customer activity in the last 90 days have been archived. Thank you to all users who have contributed, we still want to hear from you so do keep suggesting/voting. If you have any concerns that a suggestion has been incorrectly prioritised please do resubmit or get in contact.

How can we improve SQL Prompt?

(thinking…)

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

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

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

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

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. transparency

    Hi, new feature with transparency on Ctrl in SQL Prompt 9.4.10 is extremely annoying, I'm using only Ctrl+Space to show intellisense. Please provide us option to disable this feature, or change key to Alt or Ctrl+something, this is really horrible, please fix it asap. I've to uninstall tool for now.

    1 vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
    • Implement all SQL Code Guard Rules in SQL Prompt Code Analysis

      There are several rules that are only available in SQL Code Guard. And with SQL Code Guard no longer being maintained they should be implemented in SQL Prompt Code Analysis so that we can avoid having to use two products.

      By our count here are the rules currently not implemented in Code Analysis:

      DEP004 COMPUTE and COMPUTE BY clauses are deprecated
      DEP005 FASTFIRSTROW table hint is deprecated
      DEP008 PASSWORD/MEDIAPASSWORD options in BACKUP/RESTORE statement are deprecated
      DEP010 DBCC CONCURRENCYVIOLATION is deprecated
      DEP017 NON-ANSI join (*= or =*) is used
      EI001 Incompatible variable type for procedure call
      EI002 Incompatible literal type for…

      2 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
      • Move the Options - Styles configuration to the individual Style definition page

        Options - Styles pane contains, for example, "Apply column alias style" and its drop-down. This does not belong as a universal style setting, among others.

        Please move it to the "Formatting Styles" configuration dialog.

        This is because many practitioners either do not know about the "alias = column" capability in T-SQL, or don't like it, or it's contrary to company standards. The ability to use this form, which IMO is more brain-friendly, ought to be on the Formatting page as it is, in fact, a significant style element.

        Thanks.

        1 vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
        • Ability to run Code Analysis against whole DB

          With the deprecation of SQL Code Guard and it's replacement by Code Analysis there is one feature that we heavily used that is now no longer there, and that is the ability to run SQL Code Guard against the whole DB not just the query on the screen.

          This allowed us to investigate new DBs that we'd inherited to see what sort of cleanup we might be looking at as well as giving us the ability to see if anything had snuck in to our existing DBs without going file by file.

          I know there are other tools (like SQL…

          8 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            0 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
          • Allow tab history to stay open

            I want to be able to keep my tab history open. I am rebuilding a lost development database and using search a LOT, but after I search, find a tab I want to look at more deeply or execute, the window disappears and my search predicate and place in the list of matching tabs is lost, so I have to enter search predicate and scroll back down each time. This is a VERY useful tool, but it would be so much more useful if I could just keep it open.

            1 vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
            • Shift-F5: ignore other syntax errors

              Current behaviour: let's say we're editing a multi-statement script. The cursor is in the middle of one of the statements. Some other statements in the script are broken (i.e. have invalid syntax) but the one under the cursor is perfectly valid. We hit Shift-F5, expecting the current statement to be executed. Instead, we get a syntax error on some other piece of the script half a mile down the screen.

              Expected behavior: just run whatever is under the cursor and ignore all other parts of the script.

              1 vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
              • Copy a row selection and format into a into a 2 column output (column, value)

                I would like to see the ability to copy a selected row or a number of cells in a grid, and add it to the clipboard as a transposed view of the record
                with 2 columns (Column Name, Value) to allow results to be easily pasted into emails etc

                example (simple result only the result values would need to be selected)
                ID Name Activation Date
                1234 John Smith 2018-01-14

                output on clipboard

                ID 1234
                Name John Smith
                Activation Date 2018-01-04

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                • Colon style parameters

                  Some programming languages (we use FireDac in Delphi) use colon notation to declare variables. Eg

                  select * from table where id = :id;

                  Testing such queries in SQL Prompt forces you to change the query before and after testing and that is error prone.
                  It would be nice if SQL Prompt could handle this type of parameters by instead of raising an error show a "Enter parameter value" input box.

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • open source sql prompt's formatting module.

                    open source sql prompt's formatting module.

                    1 vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                    • PE019

                      I'd like to vote for adding PE019 (Consider using EXISTS instead of IN) to the issues which can be auto-fixed.

                      It feels like the kind of re-write that would probably be simpler for a computer to do than a person.

                      2 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
                      • Colors Option For Different Databases

                        Colors Option For Different Databases

                        1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                        • Universal user settings ("run as different user" scenario)

                          I use two AD user accounts on a daily basis - a normal account and a "server admin" account (for server OS local admin and SQL instance sysadmin permissions). Hence, I run SSMS as either one or the other user. SQL Prompt settings (same goes for other Redgate tools) are saved per user, which makes it quite tedious, since after every setting change I have to export from that user and import to the other user.

                          Can you it an option for settings to be user independant (universal)?

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • Disable auto update check on startup

                            It would be nice if we can turn off the auto update check for a new version on start-up. This check is happening in the Visual Studio database project and in SSMS. I'd like to disable it. Thanks!

                            2 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                            • Open Transaction Warning

                              Occasionally, developers working in SSMS accidentally leave transactions open. This causes big issues, of course. SSMS lets the user know if they try to close a tab with an uncommitted transaction, but only when the user tries to close the tab.

                              I would like a feature in SQL Prompt so that it lets the user know that they have an uncommitted transaction. SQL Prompt could prompt the user via a toast pop-up or coloring the connection tab or something

                              8 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                              • Include BEGIN TRANSACTION with "Execute Current Statement" (Shift-F5)

                                While using Shift-F5 to execute the current statement, any BEGIN TRANSACTIONS above your UPDATE are ignored, running it not in a transaction.
                                I shouldn't use Shift-F5 probably, but it's becoming a habit and could be very expensive when forgetting to highlight-execute.

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                • Custom Warnings in SQL promt

                                  Custom Warnings.
                                  For example, we have juniors who are just starting out in the SQL server world, Id like to have warning for Select statements that do not have Nolock hints. As the juniors will never be running any updates and deletes, they only have read access, but currently sometimes people forget the nolock hints and start causing locks and so on.

                                  2 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Customizable colors for database objects in object explorer

                                    It would be very useful to have the ability to define a color for certain database objects such as tables or columns. With that feature, objects could be marked individually and would be highlighted, for example columns with an index on them. Other users would be able to directly see this and take it into account in their query design for example. These settings should also be saved in the source control if desired.

                                    3 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Ignore Execution Warning on Comment

                                      I don't want to globally turn off warnings for UPDATE or DELETE without WHERE clause, but would like an authorization text that disables the warning in a given script:

                                      -- Currently Warns:
                                      DELETE FROM dbo.Person

                                      -- Suggestion - comment would authorize the delete to not warn
                                      /* Authorized */
                                      DELETE FROM dbo.Person

                                      1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • THEN expression on same line as keyword

                                        Current formatting is:

                                        CASE
                                        WHEN 1 = 1 THEN
                                        'Hello World'
                                        END

                                        I need the option to put the expression on the same line:

                                        CASE
                                        WHEN 1 = 1 THEN 'Hello World'
                                        END

                                        1 vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          1 comment  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Comment in /* */

                                          Is it possible to add a hard return after the /* comment */ block so code doesn't keep formatting after the comment

                                          Currently:
                                          /* comment */ UPDATE User
                                          SET Modified = CAST('2018-12-20' AS datetime)
                                          WHERE id = 255454

                                          Suggestion
                                          /* comment */
                                          UPDATE USER
                                          SET Modified = CAST('2018-12-20' AS datetime)
                                          WHERE id = 255454

                                          1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 9 10
                                          • Don't see your idea?

                                          Feedback and Knowledge Base