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 or our support portal.

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. Allow me to specify relationships

    I'd like to be able to give hints about how to join two tables. For example, column A in table 1 is the key for column B in table 2. It's not always possible to make that a real reference column so it would be nice if SQL Prompt knew that it should present it as an option when doing a JOIN clause.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Formatting arithmetic - new lines (Apex has this)

    The only edge Apex has over SQL Prompt formatting, at least for my use, is being able to organize long equations. If I am using a large number of columns for an equation, I'd like to place each new column on a new line.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
  3. Replace synonym with target object

    I would really like the option to select the occurrence of a synonym in DML statement and have SQL Prompt replace it with the synonym's target object.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Misc. UI Improvements

    Themes, Dark mode mainly. Ability to add company logo when you log in via browser, like we can in reports.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
  5. Create a table variable from a table

    Very often I need to create a temp table, table variable, or UDTT that is a duplicate or subset of an existing table. I'd like the @table definition to include primary key and unique constraints and any check constraints and default constraints that are in the actual table. No foreign key constraints obviously. SSMS object scripting botches this up by creating a bunch of alter statements instead of including constraints inside the CREATE statement.

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
  6. Running "Find Invalid Objects" will crash SSMS if stored procedure is encrypted

    If any stored procedures in the database are encrypted then "Find Invalid Objects" will get a null reference and prompt to restart SSMS.

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Find invalid objects  ·  Flag idea as inappropriate…  ·  Admin →
  7. code folding

    Enabled Intellisense conflicts with SQL Prompt and needs to be disabled. This also disables Code Folding feature (Outline Statements) of SSMS, which is very useful for large coding projects.
    It would be helpful if SQL Prompt were to offer the similar feature.

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  8. Ability to search contents of object within contents pop-up

    When hovering over an object like a Proc or a View, and you click the link in the pop-up to view the contents of that object. It would be nice if there was a simple search function. Many times when I'm viewing the contents of an object, it's just because I want to see where it's making a particular reference, so I have to copy, open a new tab and then search.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Download install exe option during Check For Updates

    Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
  10. Download install exe option during Check For Updates

    Can an option to download the file be added instead of just applying the update? My environment is locked down so my windows login is not an administrator, so I have to use "Run Elevated".

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
  11. Mark same columns in JOIN conditions

    It helps avoiding join on the same column (especially at inner join).
    Example:
    UPDATE A SET Column1 = B.Column2 FROM TableA AS A INNER JOIN Table B ON A.Column3 = A.Column3.
    It happens usually by accident. The statement should be:
    UPDATE A SET Column1 = B.Column2 FROM TableA AS A INNER JOIN Table B ON A.Column3 = B.Column3.

    3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add a "Copy Filename" and "Copy Filename and Path" option to Tab History

    There are times when want to be able to reference a specific file name in, for example, bug reports. This option is to allow the selected filename (or filename with path) to be copied so that is can be pasted into other documentation.

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Tab history  ·  Flag idea as inappropriate…  ·  Admin →
  13. Schema Folders

    Please introduce Schema-Folders in SQL-Server Object Explorer
    as shown in
    https://github.com/nicholas-ross/SSMS-Schema-Folders

    Or make SQL-Prompt working together with
    https://github.com/nicholas-ross/SSMS-Schema-Folders.

    The Features "Show in Object Eplorer" and "Skript Object as ALTER"
    don't work together with Nicolas Ross' Schema Folders

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Platform Support  ·  Flag idea as inappropriate…  ·  Admin →
  14. Schema Folders

    Please introduce Schema-Folders in SQL-Server Object Explorer
    as shown in
    https://github.com/nicholas-ross/SSMS-Schema-Folders

    Or make SQL-Prompt working together with
    https://github.com/nicholas-ross/SSMS-Schema-Folders.

    The Features "Show in Object Eplorer" and "Skript Object as ALTER"
    don't work together with Nicolas Ross' Schema Folders

    0 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Platform Support  ·  Flag idea as inappropriate…  ·  Admin →
  15. Fix this bug with your software and Visual Studio 2017

    Have it not break Visual Studio 2017 even when selecting that you don't want it to be integrated with it.
    The problem is that we could no longer get latest version after installing your software and then rebooting. Here is an email that I just sent to a group of people that have had the issue for at least a week before we narrowed the problem...

    Guess what!?

    We found what caused the issue, can reproduce it, and fix it.

    The issue is with Redgate’s software, specifically SQL Prompt for us.
    This is the reason that John never had the…

    6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Platform Support  ·  Flag idea as inappropriate…  ·  Admin →
  16. Ignore SQL Snippets that match table alias

    Sometimes SQL Prompt generates an alias that matches an existing snippet key. My suggestion would be to ignore snippets when it's an auto generated alias.
    example:
    select * from DataEnvironment de (where de is the automatic alias) becomes
    select * from DataEnvironment DELETE

    It's rather annoying :)

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  17. SQL Prompt storage of settings

    As we are using a dedicated group of virtual machines for using our high privilege accounts, we don't know at login time on which machine we will have a session. Currently the settings of SQL Prompt are stored under “…\AppData\Local\...”. After each logoff we loose these settings. According to the Microsoft standards, the settings should be stored under “…\Appdata\Roaming\...”. Could this be changed in a future version?

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Flag idea as inappropriate…  ·  Admin →
  18. Top with parenthesis should be a formatting option

    Changing

    SELECT TOP 10...

    to

    SELECT TOP (10)... should be a formatting option.

    3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Admin →
  19. List aggregate functions before system fields

    When putting a COUNT in a select field, the default option in intellisense is sysxmitbody.count. I understand if I have a field that contains the aggregate name in my table that you suggest it first, but I never want sysxmitbody.count - and if I do, I'd expect to go looking for it.

    I feel like I've hit this problem with other aggregates as well, but can't find another example at the moment.

    Not sure the best fix, maybe list all system tables after user tables and functions?

    2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Admin →
  20. DEP026, updated to work with spatial code

    w.sysLocationXY.STX, should not generate an code analysis error.

    1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Code Analysis  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 11 12
  • Don't see your idea?

Feedback and Knowledge Base