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 the option to Disable Tab History (Tab Magic)

    I would like to be able to completely disable the Tab History feature, as it is resource intensive (especially with large scripts).

    Our programers write their TSQL in SSMS and are using SQL Prompt for its auto-complete. they are not even aware of the Tab History feature, they do not use it (which is good for our case - they actually save their work from time to time...), but it affects performance on their computers to the point they come to me (DBA) complaining about the **** SSMS...

    It would also be nice to be able to leave only the…

    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 →
    • 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 →
      • Support MS_Description formatting

        It's currently possible to show simple string MS_Descriptions when hovering over a column, database etc.

        It would be nice if we had some formatting options. Given the closeness of SQL-Prompt to Visual Studio, something like http://msdn.microsoft.com/en-us/library/5ast78ax.aspx would make sense.

        That way, you'd be able to comment on your database schema with exactly the same language as you would comment on your code. (or in our specific case, generate the db-docs through our ORM)

        If MS_Description is not suited for this purpose, some SQL-Prompt specific extended property would be fine too.

        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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
        • sort

          It would be nice to have sortable columns in the table popup. This way we can see them in ordinal order (as it exists now), or order them alphabetically (or even by data type). Hopefully not much harder than changing a grid column property.
          This would make it much easier for our Oracle folks to accept using SSMS, as it seems all Oracle tools do this by default. It would also shut them up. :) :)

          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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
          • Add ParserLookBackDistance and ParserLookAheadDistance values to the Options menu

            Due to the length of some of the queries I write, I have to edit the file RedGate_SqlPrompt_Engine_EngineOptions.xml manually. It would be nice to be able to edit the values for ParserLookBackDistance and ParserLookAheadDistance in the Options menu. I understand the drawbacks of making these values too large. If they were in the Options menu I could adjust them for a long query and then set them back for shorter queries.

            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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
            • Add support for ALTER SERVER ROLE

              ALTER SERVER ROLE sysadmin DROP MEMBER [DOMAIN\USERNAME];

              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 for Linked Server connection to MySQL ODBC

                I have been using SQL Prompt for awhile and one of the best feature I like about it is the fact that Intellisense works even on Linked Server to other MSSQL databases.

                Recently however, I have set up Linked server to MySQL ODBC connections and I noticed that Intellisense is no longer returning the table names and column names in the predictive boxes.

                I then tested this to other ODBC connection. I set up Firebird (DB2) and Oracle and Intellisense seems to be working for these (only for table names, not columns but that's better than nothing).

                Is there a…

                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 →
                • right-click "JOIN" or operator and swap expressions

                  right click "INNER" or "JOIN" in "Table1 INNER JOIN Table2", select "swap", and get "Table2 INNER JOIN Table1"

                  --

                  right click "LEFT" or "JOIN" in "Table1 LEFT JOIN Table2", select "swap", and get "Table2 RIGHT JOIN Table1"

                  --

                  right click "RIGHT", "OUTER", or "JOIN" in "Table1 RIGHT OUTER JOIN Table2", select "swap", and get "Table2 LEFT OUTER JOIN Table1"

                  --

                  right click "=" in "ON Table1.X = Table2.X", select "swap", and get "ON Table2.X = Table1.X"

                  --

                  right click "<" in "ON Table1.X < Table2.X", select "swap", and get "ON Table2.X > Table1.X"

                  --

                  right click ">=" in "ON Table1.X…

                  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 →
                  • Improved Tab Navigation

                    Provide a better tab list for navigation than the one supplied by SSMS when there are many tabs open, for instance a resizable "navigation" window (or even a navigation tab) that easily allows filtering/grouping by server instance, database, user defined, etc.

                    As a complement to grouping tabs would be to allow naming, saving, closing, and opening of a "tab group" - related queries/script files that do not make up an SSMS "project" but are used for a particular purpose or go against a particular database, etc (user determines grouping criteria, see above). Furthermore, activating a tab group would bring its…

                    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 →
                    • results grid show joined columns as different columns

                      If columns from multiple tables in a query using a join are returned to the results grid, at the moment all results are shown and you can't tell which columns belong to which table.
                      Improvements would be to show the table name then column (e.g. a.Name in col1 b.Name in col2 etc) in the results grid heading, or colour code the results to distinguish the different tables.

                      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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                      • Replace all tabs with spaces

                        Setting the option to use spaces instead of tabs for intending (our house policy) only works for new tab presses.
                        I would like a simple action that would replace all tabs in the current document with spaces -- using the tab-to-spaces value as set in options. Sublime Text has this and I use practically every time I edit anything.

                        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…)
                          2 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                        • Like Modify for Sps have Create and Alter commands for Tables and Views

                          My colleagues and I often script out views and this requires four clicks (its not a lot but we do this many many times a week). Like Stored Procs can we have a top level Create or Alter command instead? This way its just a right click left click and no sliding around the menu.

                          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  ·  Script Object as Alter  ·  Flag idea as inappropriate…  ·  Admin →
                          • Add functionality in join to automatically choose store_id = store.id

                            In order to prevent people from deciding two tables that have the same field can automatically join, our naming tables' ID column is named ID.

                            So we frequently have queries like:
                            select a,b,c from claim
                            inner join store on claim.store_id = store.id
                            inner join target on claim.target_id = target.id

                            It seemed that this functionality used to exist, but doesn't anymore.
                            Yes, I realize that having FKeys would fix that. We'd still like the feature added. Thanks!

                            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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                            • When coding ALTER TABLE xxx DISABLE TRIGGER, list just that table's triggers, not every one on every table

                              The suggestions list after the TRIGGER is full of triggers. SQL Prompt, having been given the schema and table should narrow that list to only those present on the table to be ALTERed.

                              I would categorize this as a bug, rather than a suggestion...

                              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…)
                                1 comment  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                              • Format SQL fails when in SQLCMD mode with scripting variables

                                I have a T-SQL script that was generated with SQLCMD scripting variables like ":Setvar" and when I tell SQL Prompt to format the SQL (without highlighting a section to format) I get an error (below). I would like Format SQL to just ignore the SQLCMD variables and commands and format the know DML & DDL.

                                ---------------------------
                                SQL Prompt - Laying out SQL...
                                ---------------------------
                                SQL Prompt was unable to complete this operation.

                                Problem areas have been highlighted.
                                ---------------------------
                                OK
                                ---------------------------

                                0 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 →
                                • Right-click Context on Objects

                                  It would be nice if you could right-click on the 'tool-tip' that appears when you hover over an object (e.g. table, view, proc, function) and provide an appropriate context menu. For example, on a table, provide the same options as right-clicking in object explorer (top 1000 rows, edit top 200 rows, design, script as, etc.)

                                  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…)
                                    4 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Allow me to specify schemas to include or exclude

                                    The options to "Only load suggestions for certain databases" and "Don;t load suggestions for certain databases" are nice, but it'd be really useful to also be able to include or exclude on a per schema basis.

                                    14 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 →
                                    • Stop deleting parenthesis I type

                                      If I edit a statement like SELECT COALESCE(x, y, z) and then add some parenthetical as in LTRIM(COALESCE(x, y, z)), the last parenthetical is deleted by SQL Prompt even though I typed it. Two options are to 1) correctly establish parenthesis or 2) stop deleting characters I type correctly

                                      11 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 →
                                      • 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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Snippet Manager - Placeholder For New GUID

                                          It would be nice to have a placeholder that, when the snippet was used, was replaced with a new GUID. For example:

                                          INSERT audit.Changes (Id, Date, Reason)
                                          VALUES ('$GUID$', '$DATE$', '$CURSOR$')

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

                                          Feedback and Knowledge Base