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 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. Auto snippet generation for tables and views in a query

    In one query, be it a proc or just a scratch query, I select from the same table many times. I have auto-aliases turned on so select * from MyTableName gets completed as Select * From MyTableName as MTN.

    With auto-snippets I would like to type ssf<tab>$mtn<tab>

    Seeing as you already abbreviated one of my tables in the query as mtn you could complete it for me by switching the whole name in.

    I see this useful within a query and having the snippets extend beyond the current connection might get noisy and pointless.

    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 →
    • Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words. "Status", "Type",etc.",

      Add additional option for "remove unnecessary brackets" which would keep brackets around syntax highlighted words.
      "Status", "description", and "Type" are examples of special words that are syntax highlighted, but they aren't full reserved keywords, so would want the brackets kept.

      How to configure and prevent SQL Prompt from removing brackets around Syntax highlighted words?
      We only have the following settings:
      a) Options > Inserted Code > Special Characters > Brackets > Enclose identifiers within square brackets [] = NO (which is our desire)
      b) Options > Format > Styles > Actions > run format > Add/remove square brackets = YES,…

      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  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
      • Add in Code Refactoring

        I would like to get some simple code refactoring capabilities added to SQL Prompt. These go beyond the upper case, semicolons, etc.

        What I'm looking for is something to take the tedium out of doing mass refactors to similar procedures, which is something I constantly run into with unit tests. It gets REALLY tedious to spend an entire day doing a manual copy/paste to make the same change to hundreds of procedures, because there isn't any other way to do it.

        The best example is to be able to do something that appears to be impossible with copy/paste. Highlight multiple…

        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 →
        • Add existence check to the drop statements generated by find invalid objects.

          Add existence check to the drop statements generated by find invalid objects. If there are several objects that all have the same invalid dependency it would reduce the number of errors after that object has been dropped in the script.

          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 →
          • filter object types

            SQL Compare/Data Compare provide a very exhaustive means of filtering in (or out) the objects they care about. i would like to see something similar in SQL Prompt, where you can only specify Server/Database wildcards for inclusion.

            for example, i would like to be able to exclude all tables with a certain prefix, all objects in a certain schema, etc. this should help performance and make the actual suggestions more useful.

            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 →
            • Batch mode for the "Insert Semicolons" tool

              I have 417 procedures/functions to retrofit with semicolons. How about a batch mode for the "Insert Semicolons" tool? It would be great if you could find a way to programmatically apply the "Insert Semicolons" tool to all (or a batch) of these routines, rather than a one-at-a-time touch of each routine.

              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 →
              • Find not matched datatypes

                Implicit data type conversion produces poor performance. Provide feedback that column data types do not match.

                For example: A varchar(50) (e.g., col1, below) is being joined to a CHAR(10). (e.g. col2, below)

                This would be appropriate at least in the following areas of SQL:

                * FROM..ON... col1=col2
                * UPDATE..SET col1=col2
                * INSERT (<col1>) SELECT <col2>
                * WHERE.. col1=col2

                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 →
                • Enhance "Find Invalid Objects" to find exec of stored procedure with incorrect parameters

                  Enhance "Find Invalid Objects" to find exec of stored procedures with incorrect parameters

                  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 →
                  • Can not get table or column name by compound word

                    Need to get get table or column name by compound word

                    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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                    • Place schema's before other objects with same name in autocomplete list

                      When typing a query, e.g. in a where or join clause, writing a FQN (say, USING tempdb but querying any other database) the intellisense is not very friendly in cases where a schema has the same name of a table: in this case the table comes before the schema (sometimes many list items before), so you have to scroll to choose the correct object (otherwise a wrong completion would take place).
                      It would be nice to have schema's suggested before at least when a database name has been , so that a Tab hit would do the job immediately.

                      That's…

                      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 →
                      • Quickly change from AS [column name] to [column name] = ... and vice versa.

                        Hi there. Would it be possible to quickly change from AS [column name] to [column name] = ... and vice versa? If the SELECT has mixed namings, then use the one that the cursor is placed on. That means, if the cursor is on a row like: column_name as new_column_name, then change everything to new_column_name = column_name. And the other way round... You get the idea. Thanks.

                        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 →
                        • Quickly change where the commas are within SELECT/INSERT

                          Hi there. This one would be something that would make devs' lives so much easier :) Say you have a SELECT query and would like to quickly change the placement of commas, say, from the beginning of column names to the end (or vice versa). I'd like to be able to position my cursor on a column within the SELECT and have SQL Prompt quickly change the placement of the commas (that could be as simple a toggle invoked by a keyboard shortcut). Would that be possible?

                          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 →
                          • Selecting blocks of code based on semantics

                            Hi. I'd have a suggestion for an improvement. Would it be possible to be able to highlight/select pieces of code that constitute logical entities? For instance, I'd like to be able to select with just one key stroke the whole SELECT statement. And if the statement is used in conjunction with INSERT, then I'd like to be able to select the SELECT with the first stroke and then INSERT (together with the SELECT which is part of the INSERT) with a second stroke... You get the idea :) This is something that exists in VS. Maybe it's not a native…

                            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 →
                            • insert

                              when doing the auto complete on inserts give us an option to just fill in the column names like:

                              insert into table(col, col, col)

                              and nothing else - this is how I want 99% of the inserts that I write

                              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 →
                              • List of suggestions to select from DB

                                One of your competitors has a nice feature that would be nice-to-have in SQL Prompt as well. When you write "Select " it comes up with a list of suggestions for what to select from the current database, based on frequently used columns, in a maner where I am able to select the onces I need, without having to type the first letter of the column name. So I can easily scroll (with arrow-keys) through the list and select the ones I need - it is much faster than having to type the first few letters of the column names…

                                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 →
                                • Confirmation prompt box can be show before I do update/delete operation

                                  Confirmation prompt box can be show before I do update/delete operation, so that I will not do stupid thing in production environment.
                                  Because I am depressed to make up for the mistakes

                                  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  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
                                  • MS_Description on views inherited from table columns

                                    Since we create multiple views that inherit the exact same properties of the underlying tables, could SQL DOC or SQL Prompt either display in a tooltip the underlying table's MS_Description where the view just does a mere presentation of a column?
                                    Or perhaps when building a view, could SQL prompt suggest adding the MS_Description attributes to columns for a developer to review and accept/reject?

                                    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 →
                                    • Add Tooltip for MS_Description to object explorer

                                      Currently, we are using SQL Doc to provide a data dictionary to the development team. While SQL Prompt currently supports showing the description in a tooltip in a select statement, it would be more efficient for our developers to see this when hovering in the object explorer

                                      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 →
                                      • MS_Description supporting hyperlink when SQL Prompt is showing the tooltip

                                        I'm currently working on a database with some really complex calculations which are saved then in a table. Putting these formula in the MS_Description is a pain as it cannot be shown correctly in the appearing tooltip text.
                                        A nice Feature would be that I'm able to add a Hyperlink in the MS_Description which is pointing to the document in our SharePoint Server (or Wiki or whereever...).
                                        Or - if this is not working, would it be possible to define a Special RedGate Attribute/Property (e.g. MS_DescriptionRedGate) below the MS_Description which is containing a hyperllink and this is then shown under…

                                        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 →
                                        • Configure Primary/Foreign Key Naming

                                          We have a naming convention for SQL Server that specifies Primary Keys be named for their table with the suffix "_PK". Foreign keys are named for the source table with the suffix "_FK".
                                          Thus "customer_pk" is a primary key by definition and "customer_fk" would be a foreign key pointing to that PK.
                                          However SQL Prompt never sees the columns as possible joins because it looks only for columns with the exact same name.
                                          Would it be possible to add an Option to define Primary/Foreign key naming skeletons (something like the way ALIAS works - or maybe by ignoring specific suffixes…

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

                                          Feedback and Knowledge Base