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. "Split to Definition" as a hover-over option

    When hovering over any Table Variable, regular Variable, Parameter or Temp Table, the SQL Prompt pane is useful, even when it's just a one-liner for a variable.

    If the editor pane is or is not split, provide a right-click to enable, "Split to Definition". If already using a split-pane, re-position it at the object definition. If it isn't split, do a 1/3 split and position as above.

    For long scripts, this would be a valuable time-saver as it would obviate selecting, CTRL+F, Split (if not already split-pane), re-positioning a split to the top, then "Find Next".

    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 →
    • Enhance hover-over pane for a Table Variable to show PRIMARY KEY

      When hovering over a Table Variable, it is handy to show the column definitions, but when a PRIMARY KEY has been included in the DECLARE, there's no sign of it.

      Only found this when an unexpected PK Violation occurred in a very long SP.

      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 →
      • Summarize Script by Comments

        Allow an option in Summarize script to show summary by comments (for those of us that do a reasonable job of commenting code)! That would be more useful to a developer unfamiliar with specific complex code.

        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  ·  Summarize Script  ·  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…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Ctrl+Click to navigate code

            It would be quite convenient feature, if SQL Prompt provided for Ctrl+click to navigate, as in open in another window as ALTER or CREATE, to another stored procedure or function. For example, I am reverse-engineering business logic of thousands of stored procedures. The popup window provides some of that functionality I am recommending, but it would be more convenient if I could just open it in another editor window, or have the option to "code peek" like in Visual Studio 2013.

            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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
            • Expand a view or views referenced in a query

              I think it would be great if SQL Prompt had the functionality to expand a view that is used in a query. So if you have this schema:
              CREATE TABLE dbo.Person
              (
              PersonID INT IDENTITY(1, 1)
              PRIMARY KEY,
              LastName VARCHAR(30),
              FirstName VARCHAR(30),
              );
              GO

              CREATE TABLE dbo.Student
              (
              StudentID INT IDENTITY(1, 1)
              PRIMARY KEY,
              PersonID INT,
              StudentNo VARCHAR(100)
              );
              GO

              CREATE TABLE dbo.Class
              (
              ClassID INT IDENTITY(1, 1)
              PRIMARY KEY,
              ClassName VARCHAR(100)
              );
              GO

              CREATE TABLE dbo.ClassRoster
              (
              ClassID INT,
              StudentID INT
              );

              GO

              CREATE VIEW dbo.Students
              AS
              SELECT
              S.StudentID,
              P.LastName,
              P.FirstName,
              S.StudentNo
              FROM
              dbo.Person AS P
              JOIN dbo.Student AS…

              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…)
                1 comment  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
              • Insertion Keys for Snippets

                Use the Suggestions-->Behavior-->Insertion keys for snippets. For example, I use ii for INSET INTO. I have to type 'ii<tab>' instead of being able to type 'ii<space>' (<space> being an option I've checked under Insertion Keys).

                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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                • Enable SQL Prompt intellisense in the "SQL Pane"

                  From a visit to a customer:

                  For example when I "Edit top 200 rows" I can then "Show SQL Pane". It's frustrating that I don't get intellisense when modifying that query.

                  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  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                  • Allow me to change the way some built in objects are cased

                    When given the chance I would change things like “@@ROWCOUNT” to “@@RowCount”, for example.

                    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 →
                    • Intellisense improvement: auto insert the join condition base on the foreign key relation

                      I searched the uservoice database and couldn't find this suggestion.

                      I miss this feature from other intellisense products where Prompt suggests the join conditions after the user types JOIN

                      Currently you only get tables to which FK 's exist on top and notice (it was not clear to me at first use) that the FK's are on top with a different icon.

                      You stay much more in your flow if the fully written out join condition is an option that can be selected after you type ON

                      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 →
                      • Intellisense improvement : Write the FROM automatically for the user based on the SELECT

                        The idea is that we don't have to go back with the cursor and can always type forwards, not interrupting our flow/thinking

                        For Example,

                        User types:
                        SELECT Master.Active,

                        Prompt now makes it

                        SELECT m.Active -- Cursor stays here
                        FROM Master m

                        We still start with the SELECT but mention the table which is an indication to Prompt to wrote the FROM automatically after that.

                        Now we start with the from and go back to the select which is cumbersome if you have to do it 100 times a day.

                        This feature is also more natural to find because the developer…

                        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…)
                          0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                        • Show table joined on table prefix mouseover

                          For columns listed with a table prefix, show the table joined when you mouse over the prefix. For example, if there's a column S.qty, when you mouse over the S it would tell you the source table's name, dbo.sales.

                          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 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…)
                                1 comment  ·  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…

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

                                    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…)
                                      0 comments  ·  Smart Rename  ·  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 →
                                      • 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.

                                        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…)
                                          0 comments  ·  Intellisense  ·  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.

                                          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 16 17
                                          • Don't see your idea?

                                          Feedback and Knowledge Base