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 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. Warning if running an update/delete/alter/drop in production

    I'm paranoid that I'm going to run something I shouldn't in our production environment. I'd like a warning, akin to the new UPDATE/DELETE, that would alert on any DML/DDL statement being run in user specified environments.

    Second suggestion, could the employees of redgate officially be called redgaters? Possible logo: https://www.behance.net/gallery/7288199/Red-Alligator

    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  ·  Flag idea as inappropriate…  ·  Admin →
    • Expand the inline stored procedure functionality

      I love the new "Inline Stored Procedure" functionality. However, it appears it is only available when you right click on the name of the SP when you have EXEC <SP Name>. It would be nice if you could initiate this functionality any time you reference the stored procedure. So if it is proceeded by 'ALTER PROCEDURE', 'CREATE PROC', or if you right click on the stored procedure from within the SSMS tree (ie Server>Databaseses>DatabaseName>Programmability>Stored Procedures).

      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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
      • sql prompt doesn't recognize the new JSON syntax

        Intellisense and formatting don't recognize the new JSON syntax. Intellisense could automatically suggest columns that are nvarchar(max) & IS_JSON = 1 when you do an OPENJSON () call ... for example and the formatting just identifies parts of the JSON syntax as erroneous and won't format the query.

        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 →
        • Machine/deep learning approach to sql formatting

          What about game changing approach to sql formatting that would learn from you?
          I tried maybe all format sql products out there and i realized none of them can ever format sql by my liking. Its just not possible.
          Sometimes i want break line sometimes not, depends case by case and there is no general rule.

          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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
          • empty line

            Hi!

            Empty lines between statement : 1

            Example:

            SELECT 1

            SELECT 2

            SELECT 3

            If you only highlight SELECT 1 and SELECT 2 and the line above SELECT 2 it will be formatted as

            SELECT 1 --one empty line is missing
            SELECT 2;

            SELECT 3;

            In my opinion SQL Prompt should keep the empty line above SELECT 2 even if you highlight the line, so it should look like:

            SELECT 1

            SELECT 2;

            SELECT 3;

            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 →
            • Exclude Columns in Join Suggestions

              In many data warehouses there are common columns appended to every table, which leads to a long list of suggested joins as you're constructing queries. Examples of these types of columns include "UpdatedDate", "InsertedDate", "UpdatedBy", "IsCurrent" etc. Often times they are prefixed like "BI_UpdatedDate". It would be great to 1) have a configurable option to exclude columns based on prefixes (similar to how Aliases are configurable) or 2) add this to something picked up by the database schema scan and automatically exclude columns that appear at the end of every table

              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 →
              • Ability to quickly navigate data via keys

                I would LOVE to have the ability to right-click on a foreign key value in a resultset and click on a “View Primary Key Record” or something where it would immediately display the row from the primary data table that the foreign key is keyed to. It would be cool to work the other way as well, i.e. right-click on a primary key and have an option to “View Foreign Key Records” that you would click on and then be able to select which table of keyed data you’d like to view. It would make it SO much easier and…

                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 →
                • Format ALTER TABLE ADD CONSTRAINT (and similar) comma-delimited list to break before commas

                  ALTER TABLE ADD CONSTRAINT with comma-delimited list places DEFAULT at the beginning of the line. However, ALTER TABLE ADD with comma-delimited list of columns places commas at beginning of line. I would like the ability to place commas at the beginning of the line for the ADD CONSTRAINT (or similar) version of ALTER TABLE. Also, would like the ability to indent the list.

                  ---ALTER TABLE ADD columns example
                  ALTER TABLE report.BillingReconciliationDetail
                  ADD
                  CignaSegment NVARCHAR(256) NOT NULL
                  , CignaSalesRep NVARCHAR(256) NOT NULL

                  ---ALTER TABLE add constraints example
                  ALTER TABLE report.BillingReconciliationDetail
                  ADD CONSTRAINT DF__BillingReconciliationDetail__CignaSegment
                  DEFAULT ('') FOR CignaSegment, CONSTRAINT DF__BillingReconciliationDetail__CignaSalesRep
                  DEFAULT ('')…

                  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 →
                  • Printable list of Snippets

                    I would like a way to create a printable list of the Snippets and their description to create a handy reference. I don't have all of them memorized and having a list to reference would be helpful.

                    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 →
                    • better shape of table informationen

                      Hi!

                      It would be helpfull to get more information on the table or indexed view in the Script and Summary windows.
                      Additional tabs to visualize indexes and constraints and descriptions rather than analyzing the whole script would be cool.

                      This output should provide a script for the table creation (including all constraints and indexes like today), a tab just for indexes, a tab just for defaults, a tab just for check constraints and a last tab just for unique constraints and maybe ms descriptions.

                      So more the output like

                      sp_help 'HumanResources.Employee'

                      Today the script tab shows the following, which is…

                      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 →
                      • DBCC SHOW_STATISTICS('...','...) WITH DENSITY_VECTOR

                        Hi!

                        It would be nice to have an IntelliSense for the DBCC SHOW_STATISTICS command.

                        When typing

                        DBCC SHOW_STATISTICS('HashAggregation','_WA_Sys_00000001_2A8B4280')

                        it would be helpfull to get the option of "WITH DENSITY_VECTOR" for example.

                        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 →
                        • "Intellisense" pop-up should not truncate MS_Description

                          The Intellisense pop-up should not truncate MS_Description at ~ 190 characters (if feasible), as MS_Description itself does not seem to be limited to that size. The scope of this suggestion is only for MS_Description.

                          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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                          • deleting snippets with d

                            It would be nice if pressing the "d" key did NOT delete a snippet in the Snippet Manager!

                            It took me two key strokes to figure out why the program didn't went to the first snippet beginning with a "d" - and now I have to spend time figure out what I have been deleting!!

                            Of course, being able to navigate the long list of snippets using only the keyboard would be nice too. But of less importance. Deleting stuff without warning is bad, though!

                            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 →
                            • Don't alias objects with reserved words

                              CREATE TABLE dbo.GrumpyOld (col1 int)

                              SQL Prompt will alias the table as GO, which causes problems because it's a batch separator.

                              Thanks!

                              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  ·  Qualify object names  ·  Flag idea as inappropriate…  ·  Admin →

                                Hi Erik,

                                SQL Prompt already avoids reserved words when generating aliases, eg if you had a table called ApplicationSettings it wouldn’t generate AS for the alias as it would be invalid SQL.

                                GO is a bit of an odd case since it’s not technically a reserved word in SQL (In your example “SELECT GO.col1 FROM dbo.GrumpyOld GO” is valid)

                                But we agree that using GO as an alias is asking for trouble (and I think Prompt’s suggestions might be tripping up on it!) so it’s no longer generated as an alias in the latest beta version of SQL Prompt 7.3. You can find out more and download the beta from https://forums.red-gate.com/viewtopic.php?f=169&t=79994

                              • Make SQL Prompt a plugin for IntelliJ IDEA

                                SQL Prompt is an amazing plugin for SSMS, I would love to use this directly in my java IDE, intelliJ. If your code is not windows specific, i.e. (.NET or uses Win32 API), or is easily portable to Java or Kotlin, please consider this.

                                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 →
                                • Add schema to objects

                                  Like the fix for ; have a way to add schema to all objects without schema to fix style violations. We use SQL Code Guard so trying to fix up lots of those violation issues. An auto parameter fix for procs would be good too. So you have EXEC spSomething @val, @val2 format it to be EXEC spSomething @param1 = @val, @param2 = @val;

                                  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 →
                                  • Refactor alias SELECT formatting for consistancy

                                    Give quick syntax conversion of "SELECT x.Name AS City" to "SELECT City = x.Name" (and vice versa)

                                    My readability preference is alias = xxx, but code is generally generated placing expected column names at the end of the expression. This can be very tedious with long select item lists.

                                    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…)
                                      1 comment  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Synchronize Object Explorer with the current query window

                                      Have the object explorer automatically open and synced to the currently connected server/database for the query window. This removes the "disconnected feel" that SSMS gives with query windows and object explorer connections be out of sync.

                                      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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Ctrl+z Not working when a wrong template was generated

                                        When I am trying to use the SSF template and by mistake, i would type CSF then Ctrl+z does not work. it would be nice if we can have this option

                                        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  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Show default constraints with value/formel on summary tab

                                          It would nice to see the default value for a column within the summary tab in the mouse over for a table

                                          Regards
                                          Robert

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

                                          Feedback and Knowledge Base