Skip to content

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.

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

2 results found

  1. Don't expand wildcard occurrences within EXISTS clause.
    WHERE EXISTS(SELECT * FROM tab1)
    should not expand to
    WHERE EXISTS(SELECT col1, col2, col3 FROM tab1)

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  2. Right now, if I have

    Select * From TableA As ta
    Inner Join TableB as tb On ta.Key = tb.Key

    and I "Press TAB to expand wildcard" only the fields that are in common get qualified with the table aliases. I would like to see an option of ALWAYS having the table alias added even if there is only one table.

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?