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 https://forum.red-gate.com/categories/sql-prompt

Update (Jan 2019):
To help with internal prioritisation, suggestions with no customer activity in the last 90 days have been archived. Thank you to all users who have contributed, we still want to hear from you so do keep suggesting/voting. If you have any concerns that a suggestion has been incorrectly prioritised please do resubmit or get in contact.

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. Highlight a SELECT stmt and create a temp table definition from it.

    Highlight a SELECT stmt and create a temp table definition from it. You often need to create #tables and you have a select to fill it with. However, you have to either create the #table manually or do a SELECT INTO into a real table and then script it out. It would be nice to be able to just take my SELECT and be able to get the #table definition for it.

    19 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      4 comments  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
    • Choose to have ALTER instead of CREATE scripts

      When I hover over an object and get the pop-up script for that object (proc/view/function) I would like the ability to have the script default to ALTER instead of CREATE.

      99.9% of the time I manually have to edit the Create to be an Alter, this would save SO MUCH time.

      11 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        4 comments  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
      • Don't see your idea?

      Feedback and Knowledge Base