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. 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 →
                                • Ability to create report

                                  Need the ability to create a report form find invalid objects. Something like the reports created in SQLCompare would be ideal

                                  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  ·  Find Invalid Objects  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Bug: Identifies strings as invalid column name

                                    The following code snippet throws an invalid Column Name 'D' in a stored procedure that has QUOTED_IDENTIFIERS set to OFF

                                    ... IF @Status = "D" ...

                                    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 →
                                    • Format SQL with Obfuscation (Columns/Tables)

                                      Because most custom code is proprietary, It would be nice to have an obfuscation or masking feature. If you were able to replace all of the columns and tables referenced with a generic name, keeping the references, it would be quick and simple to share. I'm thinking like SQL Sentry's Plan Explorer where you can obfuscate the execution plan. This would be helpful so that you can quickly share code examples, without breaking a copyright.

                                      10 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 →
                                      • Retrieve BETA Updates when checking for updates

                                        I usually run the latest version of the beta and it would be nice if "Check for Updates" would pick up the latest version version of SQL Prompt, including any beta versions.
                                        Perhaps this could be an option for those that aren't interested in participating in betas.

                                        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…)
                                          2 comments  ·  Flag idea as inappropriate…  ·  Admin →

                                          The way it should work at the moment is if you have a beta build installed then you’ll get stable and beta builds on check for updates, which look something like:
                                          https://i.imgur.com/f0a1o8N.png

                                          If you have a stable build Prompt installed however you’ll only get new stable builds listed. So by installing a beta you’ll be opting into new beta builds, does this sound ok?

                                          (…and I just noticed we hadn’t added the latest few updates to CFU, I’ll make sure all the new ones are on there!)

                                        • Remove trailing spaces

                                          Option to remove trailing spaces from script lines. This can be done via search/replace functionality but it would be nice to have this taken care of automatically during the SQL code reformatting

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

                                          Feedback and Knowledge Base