Redgate

New and returning users may sign in

Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
  • Sign in
  • Sign up

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.

Feedback

SQL Prompt

Categories

  • CATEGORIES
  • All ideas
  • My feedback
  • Code Analysis 31 ideas
  • Encapsulate as new stored procedure 1 idea
  • Expand wildcards 4 ideas
  • Find invalid objects 3 ideas
  • Find unused variables 2 ideas
  • Format SQL 90 ideas
  • Intellisense 38 ideas
  • Platform Support 6 ideas
  • Qualify object names 2 ideas
  • Script object as alter 5 ideas
  • Smart rename 6 ideas
  • Summarize script 4 ideas
  • Tab coloring 2 ideas
  • Tab history 14 ideas
  • User interface 44 ideas

JUMP TO ANOTHER FORUM

(thinking…)
  • Searching…

    No results.

    Clear search results
    • DLM Dashboard 161 ideas
    • MySQL tools 21 ideas
    • Oracle 128 ideas
    • Redgate 0 ideas
    • SQL Change Automation 53 ideas
    • SQL Compare 166 ideas
    • SQL Data Compare 66 ideas
    • SQL Prompt 329 ideas
    • SQL Search 85 ideas
    • SQL Source Control 585 ideas
  • Redgate

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.

Sign in
prestine
(thinking…)
Password icon
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Cancel Submitting...
  • or
  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Show synonym script on F12

    I would like to see the Script Object as Alter (F12) feature to work with synonyms. However, I am aware that a synonym cannot be altered - instead I suggest to generate a script containing a DROP and a CREATE statement.

    That way one could bring up the code of the referenced object by selecting the synonym, pressing F12, selecting the referenced object and pressing F12 again.

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  2. Add context menu shortcuts to SQL Prompt context menu entries

    I want to be able to quickly switch between active styles.
    I'm informed that the solution to this was to add the Active Styles section of the context menu, to allow quick access to the active styles.
    That's fine as far as it goes, but that entry is very far down the menu and is only quickly accessible by mouse.

    I would like to suggest having the "Active Styles" entry changed to "&Active Styles" so that the A becomes a shortcut in the context menu; and to have each of the styles listed as &1, &2, &3 etc. in the styles submenu, so that I can get to them quickly with the keyboard.

    Hope that's clear enough. Cheers.

    I want to be able to quickly switch between active styles.
    I'm informed that the solution to this was to add the Active Styles section of the context menu, to allow quick access to the active styles.
    That's fine as far as it goes, but that entry is very far down the menu and is only quickly accessible by mouse.

    I would like to suggest having the "Active Styles" entry changed to "&Active Styles" so that the A becomes a shortcut in the context menu; and to have each of the styles listed as &1, &2, &3 etc. in the…

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  3. column alias by column name

    Feature to automatically add column alias with the name of the column.
    E.g.:

    SELECT Column1
    FROM Table1 AS t1

    changes to:

    SELECT Column1 AS Column1
    FROM Table1 AS t1

    If the name can not be found add a dummy-alias like Exp1

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  4. Formatting Styles - More granular control?

    I realize my title is very vague.

    Basically, I would like more control options over how styles are applied. Maybe I'm just really weird in how I format my SQL, but it seems like no matter how hard I try, I can never get the styles the way I want them.

    I realize that it's impossible to make it perfect. But the basic idea is to get the formatter to do what you would normally do the majority of the time.

    For example....the majority of the time, I prefer the following...

    For JOIN clauses, all join criteria is in the same line:

    JOIN dbo.Table t ON t.Foo = x.Foo AND t.Bar = x.Bar
    

    But for WHERE clauses, I prefer them to be on separate lines:

    WHERE x.Foo = 1
    
    AND x.Bar = 2
    AND y.Baz = 123

    Unfortunately, the formatter only allows one or the other.

    Another example, is with lists:
    For GROUP BY, I like them all on the same line

    GROUP BY x.Foo, y.Bar, z.Baz
    

    But for SELECT, I like the columns on separate lines (unless it's a short list, then put them all on the same line.)

    Unfortunately, the formatter also does not allow this. So now all of my group by's look like this:

    GROUP BY x.Foo
    
    , y.Bar
    , z.Baz

    I have a few more examples, but they're more oddball things that I like to do that are probably not as common.

    I realize my title is very vague.

    Basically, I would like more control options over how styles are applied. Maybe I'm just really weird in how I format my SQL, but it seems like no matter how hard I try, I can never get the styles the way I want them.

    I realize that it's impossible to make it perfect. But the basic idea is to get the formatter to do what you would normally do the majority of the time.

    For example....the majority of the time, I prefer the following...

    For JOIN clauses, all join criteria is in the…

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  5. Import and Export Aliases

    It would be nice to have the ability to mass import/export aliases.

    2 votes
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →
  6. Remove/replace String Literals

    When you code a SELECT statement as:
    SELECT EffDt AS 'EffectiveDate'
    SQL PROMPT advises that string literals as column aliases have been deprecated.
    Have an option to convert string literals, similar to Remove Square Brackets. In this case, Convert Column Aliases would either remove the apostrophes, where appropriate, or add square brackets if required (e.g. the alias contained special characters, a space or reserved word).

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  7. Run Script at Cursor

    Run Script at Cursor just Oracle SQL Developer with F5 or Alt+X. Please implement this very helpful functionality.

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  8. Writing text within quotes

    When typing a string of text within a quote, do not replace my text with objects from the database.

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  9. COLUMNPROPERTY

    COLUMNPROPERTY (https://docs.microsoft.com/en-us/sql/t-sql/functions/columnproperty-transact-sql) is missing two suggested property values that were introduced along with System-Versioned tables in SQL Server 2016.
    Please find the missing values below:

     GeneratedAlwaysType
    
    IsHidden

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  10. add trigger definition to a triggers tab on object definition box

    Currently, when hovering over table objects, and clicking on the table name mini popup, you get the object definition box, with a 'Script' and 'Summary' tab.

    The 'Script' tab has the table and index creation scripts, and the 'Summary' tab lists the column definitions.

    For tables with triggers, it would be nice to have a 'Triggers' tab that contains
    any trigger scripts for the table.

    https://documentation.red-gate.com/sp/sql-code-completion-and-intellisense/using-the-object-definition-box-and-object-tooltips

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Summarize script  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  11. inserting table adds database name

    When you select a table from the intellisense list
    Precede the table name with the database name as well
    Currently it is only inserting the schema name in front of the table name
    i.e. dbo.<table name>

    It should be <database name>.<schema name>.<table name>

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  12. Display intellisense for view columns from underlying base tables

    When working with views, you lose the intellisense for columns. It would be nice if SQL Prompt could get the MS_Description value for the view column from the underlying base table for the view.

    2 votes
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →
  13. Provide support for "Suffixes to ignore" in "Insert code > Aliasing" options

    We use a data warehousing strategy that creates potentially dozens of tables for multi-class entities in the data warehouse, so we have many tables that end in "core". This leads SQL Prompt to alias the object with a final "C" that we then remove manually. For example, our InstanceCore and Database_Core tables are aliased to "IC" and "DC" when we would prefer "I" and "D" respectively.

    Can SQL Prompt's Aliasing capabilities be extended to support "Suffixes to ignore" just like the existing "Prefixes to ignore"?

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  14. Improve Autocomple

    After Update to 10.0.
    When you for example press J for join and confirm this input with Tab, it wont add a Space. You have to add this space manually :(
    maybe it is possible to add automatily always the space

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  15. Move caret within python_case_identifiers similar to CamelCase

    Similar to the movement of caret within CamelCase, could you please enable such behavior for pythoncaseidentifiers? I'd like the caret to stop in these places when using CTRL+<right or left arrow>: (1)python(2)case(3)identifier. Would that be possible, please?

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  16. Formatting of the invocation of a stored procedure

    Hi there. Currently, SQL Prompt formats an invocation of a sproc like this:

    exec sproc @param1 = ?,

    @param2 = ?,
    
    @param3 = ?

    I'd like to be able to change this into:

    exec sproc

    @param1 = ?,
    
    @param2 = ?,
    @param3 = ?

    Thanks.

    4 votes
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →
  17. Allow item following AND/OR to be on new line

    When formatting SQL, it would be good to have the option to put the item following an AND/OR on a new line and align it, so instead of:

    WHERE

    OutgoingResults.LoadDateKey = 20191106
    

    AND OutgoingResults.FeedName = 'TestFeed'

    we have

    WHERE

    OutgoingResults.LoadDateKey = 20191106
    

    AND

    OutgoingResults.FeedName = &#39;TestFeed&#39;
    

    7 votes
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Delete…  ·  Admin →
  18. Pin tab

    So, Starred Tabs have been added, which is 1/2 of the capability I asked for a while back with "pinned tabs". We can remove tabs from Tab History either:
    1 tab at a time.....100s of times per day for me
    Older than x date - which does NOT work for me, because tabs that I want to keep around aren't always used every day

    So, now that we can "Star" tabs, how about letting us clean up Tab History a little more cleanly. Such as:
    1 tab at a time
    Older than x, except Starred Tabs
    Older than x

    This allows me to Star a tab to keep it around without having to open them all every day just in order to be able to do a mass clean out by using the "tabs older than x" feature.

    So, Starred Tabs have been added, which is 1/2 of the capability I asked for a while back with "pinned tabs". We can remove tabs from Tab History either:
    1 tab at a time.....100s of times per day for me
    Older than x date - which does NOT work for me, because tabs that I want to keep around aren't always used every day

    So, now that we can "Star" tabs, how about letting us clean up Tab History a little more cleanly. Such as:
    1 tab at a time
    Older than x, except Starred Tabs
    Older than x

    This…

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  19. Only load suggestion for fresh new databases

    Do you think it's possible to only have the refresh of suggestions the first time a database is loaded (so skip refresh if the cache already exists, but let the possibility to manually refresh cache for this db with the contextual menu of course)

    We have hundred of databases (with thousands of view and sp) and sql prompt try to refresh all the time the same databases (for example when we restart Management Studio) and nothing never change in these databases ...

    So we would like to load schema automatically only the very first time and then on demand.

    Thanks

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Intellisense  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
  20. flip between adding and removing square brackets

    Add ability to add or remove square brackets without having to edit the settings for which direction you want it to go.

    1 vote
    Sign in
    prestine
    (thinking…)
    Password icon
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
← Previous 1 2 3 4 5 … 16 17 Next →
  • Don't see your idea?
Redgate
Redgate Terms of Service Powered By UserVoice

Your password has been reset

We have made changes to increase our security and have reset your password.

We've just sent you an email to . Click the link to create a password, then come back here and sign in.