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

    16 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

      3 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
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        4 comments  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
      • Enable F12 for table definitions (and other objects)

        F12 works great for viewing the definition of a procedure. How about doing the same trick for a table/view. i.e. highlight a table, press F12, and see the CREATE TABLE script for that table.

        7 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

          5 comments  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
        • Enable F12 from Object Explorer

          It would be nice to highlight an object in the Object Explorer, hit F12, and have the ALTER script in a new tab already named appropriately.

          6 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  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
          • 3 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  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
            • Resharper style 'Ctrl-T' go to type(/go to object)

              Similar to Resharper's 'goto type' - a keyboard shortcut is used to bring up a search box. This then suggests objects from the database based on partial matching of the input. On selection of an object, a script-as-alter query window is opened for the object.

              3 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  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
              • Add extra features to object generation code when the mouse cursor points to object in editor

                When I point on the object in editor it generates the script for that object. It would be nice to have some kind of dropdown list with checkboxes or something like that to add some extra conditions what objects to generate. For example for table it generates: table code, constrains, indexes... Sometimes I want to see there triggers, maybe permissions, something else.

                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  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
                • 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  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
                  • Script Object as alter (F12) should be able to open an object even when it does not follow an EXEC or begins a batch.

                    I often want to open a procedure that is inside dynamic sql or in a list of objects. Today I have to put an EXEC in front of statement. F12 ought to be able to find the proc/function/view anyway.

                    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

                      1 comment  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
                    • 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  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
                      • design view

                        I like how I can use 'ap' and a stored procedure name to quickly edit a stored procedure, without having to use the solution explorer to find it and right click etc.
                        It's a bigger ask, but I'd like a shortcut I can also use to open a table up in designer view. Something like 'at' and then intellisense the table name, and then when I hit tab, it opens the table up in design view.

                        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  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
                        • When typing after selecting an object the source popup appears. Shortcut key to the copy button

                          Often when working on a database object will type exec procname/select * from view/table. When the desired object is selected with arrow keys a Sourcebox popup appears with a Copy button. A shortcut key to this button would be fantastic. Fingers on keyboard instead of finding mouse.

                          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  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
                          • Like Modify for Sps have Create and Alter commands for Tables and Views

                            My colleagues and I often script out views and this requires four clicks (its not a lot but we do this many many times a week). Like Stored Procs can we have a top level Create or Alter command instead? This way its just a right click left click and no sliding around the menu.

                            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  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
                            • Generate SET [OPTION] for when altering procedures

                              When auto-generating source for ALTER PROCEDURE, make sure to replicate the original options settings. For example, generate a "SET QUOTED_IDENTIFIER OFF" if the procedure originally had this setting.

                              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  ·  Script object as alter  ·  Flag idea as inappropriate…  ·  Admin →
                              • Don't see your idea?

                              Feedback and Knowledge Base