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. Find Results

    Create similar panel like Find Results for Find Unused Variables and Parameters in Microsoft SQL Server Management Studio.

    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  ·  Find unused variables  ·  Flag idea as inappropriate…  ·  Admin →
    • Enhance "Find Unused Variables and Parameters" to look for unused JOINs, too.

      Would be nice if this option (or a new one) highlighted JOINs that are not used elsewhere in the query. As applications evolve or new ones added, desired information may shift to a new table, and the old column retained for legacy purposes. When we revise a procedure to use the new information instead, the old JOIN may become unnecessary, and "housekeeping" to clean these up can cause problems in large queries if not done carefully. Would be acceptable if use of this feature required the use of table aliases, if that would make it easier to implement.

      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  ·  Find unused variables  ·  Flag idea as inappropriate…  ·  Admin →
      • Thanks for providing a feature to find all the unused variables but can you please provide a feature to comment/remove unused variables?

        Step 1: At first I want to comment out all the unused variables.
        Note: In these comments there must be a keyword (e.g. UVC To make it different from other comments) which can be helpful to remove it later after proper testing.

        Step 2: After some testing(may be in if I find everything works fine I want to remove all the unused variables permanently to make a final copy.

        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  ·  Find unused variables  ·  Flag idea as inappropriate…  ·  Admin →
        • Find unused columns in SELECT statements

          Find unused columns in SELECT statements similar to finding unused variables.
          Use case: I have some subqueries where I expanded SELECT * to now explicitly specify column names (best practice). However, only some of the columns and then used in the query process or results. I thus want the ability to have the unused columns removed from the SELECT statement.

          12 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

            1 comment  ·  Find unused variables  ·  Flag idea as inappropriate…  ·  Admin →
          • Automatically find unused variables and parameters

            I would be nice to have an option i behavior to automatically finding unused variables and parameters. (like suggestions / definitions)

            56 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  ·  Find unused variables  ·  Flag idea as inappropriate…  ·  Admin →
            • Don't see your idea?

            Feedback and Knowledge Base