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. Propagate smart-rename through foreign key hierarchy

    For example, if table Person has Person_ID, and table Employee also has Person_ID which has a foreign key relationship to Person.Person_ID, then I smart-rename Person.Person_ID, it would be spectacular if Employee.Person_ID was also similarly renamed.

    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  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
    • Formatting profile compatible with sqlstyle.guide

      I wondered if it would be of interest to add an auto formatting profile in line with http://www.sqlstyle.guide

      It is a SQL code style guide that I published recently.

      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 →
      • prevent Prompt SQL from destroying bookmarks

        If format SQL makes chnages - it destroy saved marks
        This occurs even when line bookmarked line hasnt (visibly) changed
        Very frushtrating

        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 →
        • Ability to filter columns in invalid object list

          Ability to filter columns in invalid object list

          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 →
          • Add button for SET STATISTICS IO / TIME

            I'd like to have an toolbar botton to enable / disable the SET STATISTICS IO / SET STATISTICS TIME for the current session similar to SSMS's build in buttons for Show actual execution plan or Show client statistics

            Currently I have either to modify the query options or have to type it in manual (or using my "sio"-snippet) which is a little bit annoying.

            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 →
            • Shift+F5 for executing the current statement is awesome, please make it work even when there is an incorrect query elsewhere on the screen.

              Shift+F5 for executing the current statement is awesome, please make it work even when there is an incorrect statement elsewhere on the screen.
              Semicolons and GOs can be used to separate the statements if needed.

              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 →
              • Smart Rename does not update when used in cursors.

                **BUG** - I ran a smart rename on all of my tables to change from TableName to tblTableName. I did this for ~15 tables and everything looked fine until I ran the code. Many of my stored procedures us cursors, and I found that none of my cursors were updated with the new table names.

                Notice:
                ```sql
                SET @myCursor = CURSOR FOR SELECT MyField FROM dbo.MyTable WHERE MyFlag = 1
                ```

                Run [Smart Rename...] on MyTable to change it to tblMyTable.

                Notice that the cursor definition does not get changed.

                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  ·  Smart rename  ·  Flag idea as inappropriate…  ·  Admin →
                • Append "SELECT SCOPE_IDENTITY()" for ii (INSERT INTO) fragments if the table contains an IDENTITY column

                  Suppose I have a table test (Id IDENTITY, Name VARCHAR(20)). Today, when type ii<tab>test<tab> SQL Prompt generates the script

                  INSERT INTO dbo.test
                  ( Name )
                  VALUES ('')

                  Because the table test contains a column of type IDENTITY, it should instead generate the commands

                  INSERT INTO dbo.test
                  ( Name )
                  VALUES ('')
                  SELECT SCOPE_IDENTITY()

                  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 →
                  • Command Line "Reformat All Files In Folder" and pre-Commit

                    Opening over 2500 code objects to set a baseline format, required by a large customer, is a daunting manual task.

                    Many of Red Gate's tools provide command-line functionality.

                    Please add it to Prompt so we can bulk (re)format SPs, UDFs, Triggers. Integration into the commit-path (we use SVN) would be ideal for standardized check-ins (Commits).

                    Can't recall whether a style is exportable... (License key awaited at new employer) Should be able to point to UNC location for the style to use.

                    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 →
                    • Option in Format SQL to Preserve W

                      Provide an option to Preserve Whitespace. I like to spread things out for easy visibility:

                      SELECT xxxxxx
                      ,yyyyyy
                      ,zzzzz

                      FROM yyyyyyy

                      JOIN aaaaaa
                      ON wwwww = uuuuuu

                      JOIN........

                      JOIN.........

                      WHERE vvvvvv = eeeeeee

                      AND.....

                      etc., etc.

                      When I run Format SQL it takes out all of my carefully inserted whitespace; please add an option not to do that.

                      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 →
                      • Generate Scripts Based on the Result Grid

                        Just like in Toad and SSMSBoost, there's a facility to create a script such as INSERT based from the given result grid. This would be handy in generating test data or re-populating tables

                        71 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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                        • Creation of Folders for Tables and Stored Procedures

                          It would be great, if I could create custom folders in the SSMS to organize hundreds of tables, stored procedures, views ...

                          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…)
                            2 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                          • Display foreign key relationships graphically inside the script and summary window

                            When coding delete queries it would be useful if there would be a graphically representation of the foreign key relationships of the object you are deleting on.

                            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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                            • Link users to a github repo of snippets where they can clone/contribute/fork as they desire: https://github.com/gvohra/sqlpromptsnippets

                              A lot of users are asking for more snippets, or ways to share snippets with teams. How about linking people to a public repo on github where they can clone/contribute/fork as they like?

                              I've just set one up here which has all the Red Gate defaults, plus about 50 key others I have added (like gb = GROUP BY):

                              https://github.com/gvohra/sqlpromptsnippets

                              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 →
                              • try snippet

                                It would be nice to have a TRY CATCH snippet.

                                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  ·  Flag idea as inappropriate…  ·  Admin →
                                • I would like to be able to manager 'tab magic' feature, like dont save the last couple years, or filter it to x monthes, days, etc

                                  implement filter and or manager of tab history. like show the last 2 months or days or whatever. The Manager I could just delete or removed outdated items. I have been using tab history since day 1. when I run it, I feel I have an pulling up too much for program to handle. it takes too long now

                                  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  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
                                  • SYSDATETIME() instead of GETDATE() as default value for datetime2 columns

                                    When generating an insert script with default values for a table, use SYSDATETIME() instead of GETDATE() for datetime2 columns. GETDATE(), is fine for datetime columns, but for datetime2 columns, which have a larger precision SYSDATETIME() would be more appropriate.

                                    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…)
                                      4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Allow Multiple Snippet Folders

                                      Hi, I think it would be useful to add support for multiple snippet folders to the SQL Prompt - Snippet Manager. I would use this by connecting to a set share of snippets that our team uses as well as having my own set of snippets that may be useful only to me.

                                      Thanks for considering,
                                      James

                                      8 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 →
                                      • when clicking a table currently we see table structure and columns, please display primary keys

                                        when clicking a table currently we see table structure and columns, please display primary keys and foreign keys that are in this table along with Table name

                                        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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Sort suggestions by closest match

                                          What I mean by closest match varies between match types. In the case for camel case (or underscore-separated first letter matching), the closest match would be the one that has the exact initials. Next closest would be ones with additional suffixes, those with prefixes, and then those with intervening content between matched initials. Somewhere in there should be any matches with the search value as a direct substring. For the case of substring matches, an exact match should be first, then matches closest to the beginning of the name should be listed next, sorted by suffix length (or alphabetical for…

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

                                          Feedback and Knowledge Base