SQL Prompt Feature Suggestions

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

How can we improve SQL Prompt?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  1. 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.

    11 votes
    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)
      You have left! (?) (thinking…)
      5 comments  ·  Script Object as Alter  ·  Flag idea as inappropriate…  ·  Admin →
    • Alter object directly from SQL Search results

      I would like to alter object directly from SQL Search result without having to double-click them and then right clicking and altering them via object explorer.

      7 votes
      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)
        You have left! (?) (thinking…)
        0 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.

        7 votes
        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)
          You have left! (?) (thinking…)
          1 comment  ·  Script Object as Alter  ·  Flag idea as inappropriate…  ·  Admin →
        • Surround templates added to snippet manager.

          So you could highlight a column and surround it with isnull() for example.
          Or surround a sql query and surround it with begin and end.

          5 votes
          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)
            You have left! (?) (thinking…)
            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.

            3 votes
            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)
              You have left! (?) (thinking…)
              0 comments  ·  Script Object as Alter  ·  Flag idea as inappropriate…  ·  Admin →
            • 2 votes
              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)
                You have left! (?) (thinking…)
                1 comment  ·  Script Object as Alter  ·  Flag idea as inappropriate…  ·  Admin →
              • 2 votes
                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)
                  You have left! (?) (thinking…)
                  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.

                  1 vote
                  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)
                    You have left! (?) (thinking…)
                    1 comment  ·  Script Object as Alter  ·  Flag idea as inappropriate…  ·  Admin →
                  • Don't see your idea?

                  Feedback and Knowledge Base