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. Highlight all occurences of selected identifeir/word

    When dealing with large scripts it would be really helpful to have highlighted all occurences of selected identifier or word.

    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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
    • Let cursor jump to capitalized letters within words (CTRL+arrow)

      Hi there. Would it be possible to program a feature that is
      present in Visual Studio (I think ReSharper brings it
      into VS) which enables a programmer to select/move among
      parts of a word based on where the capital letters are? (CTRL+arrow)
      Say you have a variable called @ThisIsMyVariable.
      If you place the cursor at the end of the word and then
      press CTRL+<Left Arrow>, then it’d be nice if the cursor
      jumped to the beginnig of the next capital letter instead
      of the next word as is usual. This feature is very helpful in VS and I think it’d…

      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 →
      • Warning on delete and update statements if no WHERE clause is specified

        It would be nice to get a warning on delete or update statements if you did not specify a where clause.

        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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
        • Pin feature for quick info

          When the mouse pointer is hovered over a table or stored procedure etc, an intelli-sense like link is shown which can clicked to bring up the object definition, which disappears when something else is selected.

          My suggestion would be a pin feature, so that we can keep the object definition quick info box visible on the screen for reference instead of it disappearing.

          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 →
          • aliases ignore suffix feature

            I use the ignore prefix feature and it works great. However, some databases use suffixes on their objects (Salesforce, for example uses __c for custom objects) - I would like to be able to specify the ignore portion as a prefix OR suffix.

            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 →
            • Suggest Table depending on pre-typed Columns in SELECT clause

              If I already typed one or more columns in the SELECT clause of my statement, followed by FROM, SQL Prompt should sort those tables, that contain columns of those names to the top of its suggestion box.

              For instance typing:

              "SELECT customerID, name FROM " would then open the list of tables, with those that contain columns "customerID" or "name" to the top.

              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 →
              • Tab History (aka SQL Tab Magic) should not show currently open windows

                I love Tab Magic (or Tab History), but the with the latest version it also shows the tabs that are currently open. I would like an option to ignore currently open tabs. I can search those tabs right in SSMS, I need Tab History just for ones I've already closed.

                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 →
                • Add squiggly red line under issues like SSMS intellisense

                  Please add the ability to identify issues like the squiggly red line in SSMS intellisense

                  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 →
                  • Concatenated items on their own line

                    When creating longer dynamic SQL strings from various pieces, it would be nice to be able to set each concatenated piece to be on its own line, perhaps with some indentation. Could even add a setting to keep the "+" on the beginning or end of a line, like the current setting for commas.

                    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 →
                    • Tab Coloring

                      Had this discussion with some folks at work today. SSMS Toolspack does tab coloring but it places a color band across the entire width of the query editor while SQL Prompt's tab coloring only colors the tab. The whole line is a much more obvious reminder. Be great if SQL Prompt did a similar thing. I realize Tab coloring is an experimental feature still.

                      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…)
                        3 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                      • "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.

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

                                  13 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.

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

                                          Feedback and Knowledge Base