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?

(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. Option to disable Tab key from popping up suggestions

    I would like an option that can disable the tab key from popping up the suggestions menu/popup. When I am formatting my code in SSMS using the tab key to line up various items, each time I hit tab, the suggestions menu pops up.

    MOST of the time this isn't an issue other than ignoring the pop-up. Occasionally, based on what is in the code I am formatting, when I hit tab it will auto select an item in the suggestions, and the second tab will insert the suggestion. This slows me down quite a bit.

    In the mean time,…

    1 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)

      We’ll send you updates on this idea

      0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
    • Add option to default time to either UTC or local when expanding parameter lists.

      I would like to see an option to default times to either UTC or local time when expanding stored procedure parameter lists. Many larger companies are distributed across time zones and use UTC rather than local time but the vastly more numerous smaller organizations operating in a single location, generally use local time. Having to manually edit all the times in a parameter list somewhat limits the value of default values.

      1 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)

        We’ll send you updates on this idea

        0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
      • Detect the database compatibility version

        When using SQL server 2016 with a database that has it's compatibility level set to 2012, I'm still being offered auto complete options for 2016 features. e.g. string_split

        SQL Prompt needs to detect the database compatibility level and adjust it's intellisense accordingly.

        1 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)

          We’ll send you updates on this idea

          0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
        • Joining tables from other database tables does not include database name prefix with suggested join tables

          I created a query that joins tables from another database (dbname..tablename) and had to join another table from that database.
          The table I wanted to use came up as a suggestion because of the relation between those two tables. So I selected the table, but the databasename prefix wasn't added. That was a bit unfortunate

          2 votes
          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)

            We’ll send you updates on this idea

            0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
          • disable the column picker for IN clauses

            Give us the ability to disable the column picker for an IN clause, so that when you're trying to say "IN (3,4,5)", it doesn't keep popping up suggestions for a field.

            4 votes
            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)

              We’ll send you updates on this idea

              0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
            • If the database settings password is empty, then the smart prompt does not come

              If the database settings password is empty, then the smart prompt does not come

              1 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)

                We’ll send you updates on this idea

                0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
              • Include column picker for where clause and allow entering of variables/values

                When you type the WHERE clause, allow the user to choose from the column picker with textboxes on the right to allow the user to input the values.

                e.g.
                [ ] ID Value [_____________]
                [ ] Name Value [_____________]
                [ ] Surname Value [_____________]
                [ ] ID Number Value [_____________]
                [ ] Cellphone Number Value [_____________]

                0 votes
                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)

                  We’ll send you updates on this idea

                  0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                • Suggest correlated subquery "join" criteria

                  When doing a correlated subquery, like:

                  SELECT
                  FROM Table1
                  WHERE NOT EXISTS (SELECT *
                  FROM TABLE2
                  WHERE <--- pop up here

                  Do the same matching as if we had written:

                  SELECT
                  FROM Table1
                  JOIN TABLE2
                  ON <--- pop up here

                  3 votes
                  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)

                    We’ll send you updates on this idea

                    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                  • New Snippet HAVING COUNT(*) > 1

                    Maybe there is a section of the site just for snippet suggestions, but here is one I use all the time:
                    hav = HAVING COUNT(*) > 1

                    1 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)

                      We’ll send you updates on this idea

                      0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                    • Allow user to define order that schema appears in suggestions

                      I would like to be able to define the order that a table appears with schema suggestions in the Suggestions menu for auto complete.

                      Example: I have TableX in both dbo and archive schemas when I type
                      select * from Table; I want the suggestions to show TableX for dbo and then TableX for archive.

                      1 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)

                        We’ll send you updates on this idea

                        0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                      • Snippets: Database-specific Snippets

                        I would like database-specific snippets. Many table-names occur across databases but have different schemata.

                        Rather than the snippet manager loading all snippets for each DB, it would make more sense to bind a snippet to specific databases.

                        2 votes
                        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)

                          We’ll send you updates on this idea

                          0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                        • Snippets: All snippets in one CSV file (or in one table on a specified DB)

                          Having all of the snippets as individual files is annoying. When I take charge of a new database, I have to spend an hour or two entering all of the various table and other object names manually.

                          Ideally, I would like to be able to run an SQL script and save the lot in one CSV file. It would be easy then to edit in Excel. An alternative would be to store the details in a database table of my choosing.

                          1 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)

                            We’ll send you updates on this idea

                            0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                          • Create package for Visual Studio Code

                            Visual Studio Code has the ability to connect to SQL servers and execute scripts. It would be nice if SQL Prompt was available for Code as well.

                            16 votes
                            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)

                              We’ll send you updates on this idea

                              4 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                            • Don't suggest join keys I've already used

                              After I type
                              SELECT * FROM sys.indexes i
                              INNER JOIN sys.partitions p
                              ON i.index_id = p.index_id
                              AND

                              the IntelliSense still suggests me i.index_id = p.index_id which I've already used. These duplicates can become pretty annoying when multiple columns are used for joining

                              16 votes
                              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)

                                We’ll send you updates on this idea

                                0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                              • ExecuteCurrentStatement prompts error if overall script syntax is incorrect

                                ExecuteCurrentStatement is a wonderful command! I have bound to Ctrl + Enter and it's saved me tons of times without having to highlight a query (god knows where some of them start and end sometimes)

                                Unfortunately, it doesn't work when there are syntax errors in somewhere else in the script. For example:

                                /****** Code start ******/

                                UPDATE MyTable
                                SET SomeValue = 5
                                WHERE SomeRow =

                                // What was the SomeRow value I wanted to look for again?
                                // So I write another query to look for it

                                SELECT SomeRelatedRow
                                FROM MyRelatedTable

                                /****** Code end ******/

                                It's a simple example (sure,…

                                1 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)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                • Add Intellisense Support for USQL in Visual Studio

                                  Can we have USQL intellisense support within Visual Studio when developing with Azure Data Lake please? This would be really helpful please.

                                  3 votes
                                  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)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Disable Auto Generated INSERT Statement By Keyboard Shorcut

                                    Auto generat INSERT statement is a great feature. But some times I come across a table with a lot of columns and do not want prompt to generate insert statement only for one time.

                                    Maybe it should be like this :

                                    Enter will generate full insert statement
                                    Shift + Enter will generate only table name.

                                    1 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)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Add / Edit / Delete MS_Description in context menu

                                      it would be nice, if I could create or alter the MS_Description property of an object (table, view, function, procedure, index, sequence ...) or column via context menu / shortcut, since it is very annoying to navigate to the object in the Object Explorer, open its properties, go to Advanced, enter MS_Description, click onto the ...-Icon and enter my description (for columns it would be one or two steps more).

                                      Bonus points for giving me the choice of applying my changes and / or create change scripts

                                      1 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)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Discover metadata for OPENQUERY

                                        When I use the OPENQUERY syntax to retrieve data across servers, SQL Prompt does not discover the metadata (column names, data types, etc.) of the fields returned.

                                        My suggestion is that you add support within SQL Prompt to make metadata for fields retrieved by OPENQUERY available just like you do for linked servers.

                                        3 votes
                                        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)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Index-based Column & Grouping Suggestions

                                          Good database design would suggest thoughtful indexes are in place on tables based on expected usage. It seems like this thoughtful index creation could be utilized to simplify and encourage good select/grouping behavior in queries to maximize index utilization by the database engine.

                                          As such, having index names show up in intellisense suggestions for column lists in the SELECT and GROUP BY statements of a query, which then expand to the columns included in those indexes, would be extremely helpful.

                                          Presumably with the "Included" columns in SQL Server indexes, including only the indexed columns in the GROUP BY column and…

                                          2 votes
                                          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)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 6 7
                                          • Don't see your idea?

                                          Feedback and Knowledge Base