SQL Search

Welcome to the SQL Search feature suggestion list. Find out more information about SQL Search at http://www.red-gate.com/products/sql-development/sql-search/

How can we improve SQL Search?

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

  1. Ability to have each match in same procedure listed separately in results

    So I don't have to scroll to the end of each matched procedure to be sure there are not additional matches later in the file. Also make it less likely to miss a match when quickly scrolling.

    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…)
      0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
    • Aggregate results base on "Matches on" column, to avoid duplicate result rows

      Aggregate results base on "Matches on" column, to avoid duplicate rows

      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  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
      • Please refresh before search or add refresh button.

        Please refresh before search or add refresh button. DB doesnot reflect until we close and open SQL search again

        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  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
        • Searching for a datatype, such as TINYINT does not return results from table definitions.

          I needed to find all the tables in an existing database that utilized TINYINT columns to research if there would be a problem changing them to INTEGERS, and search for all the places in SQL code that the TINYINT datatype was referenced. I reached for SQL Search as the ultimate solution but determined that it doesn't find datatypes within table definitions. I was able to use it to identify the places in stored procedures, etc. but not within the table object definitions. This feature was expected functionality on my part.

          4 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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
          • Add Created Date to Result Set

            Can you add the Created Date to the result set? That is helpful to find queries that were created recently to do various tasks like trouble shooting new queries that are affecting performance.

            4 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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
            • Ability to copy results

              Allow selective copy from top panel. EG, sort by Type, then copy the list of Tables only, not DB, Schema, Type, and the lengthy detail

              6 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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
              • Show the Row Counts and Last Update date of the tables.

                We often have to explore large databases with 100's of tables, many which have no or few rows. Row counts help us understand how actively used a table is and helps us avoid tables we no or few rows. Last update date helps us understand if a table is still being used.

                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…)
                  0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                • Ability to dock windows into columnar format

                  My preference would be to be able to view more lines of the object window at a glance (reduce scrolling). I don't need to see so much of the info in the search results window.
                  Include the ability to resize each window.

                  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…)
                    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                  • Print List

                    Once the list is generated allow the printing or export of the list.

                    Cheers

                    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  ·  Flag idea as inappropriate…  ·  Admin →
                    • Ability to set default databases to search in

                      Give the users the ability to set default databases to search in, so that when ever the SQL Search is done, it saves them the time to select their mostly searched databases

                      16 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  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add a refresh button to redo the search

                        Add a refresh button to redo the search

                        4 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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                        • 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…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • I would like to see history of my search and to be able to re use it fast, right away in search box.

                            I would like to see history of my search and to be able to re use it fast, right away in search box. The idea is that almost all the time I’m working with 2-4 tables, SP and views and it will be helpful to me to get last 10 used search text at once. A text is selected when I do Navigate to Object function.

                            The list could be like combobox or like auto complete /with text that has been used already/.

                            I’m sure this will be in help for all persons using you great search tool. I’m using…

                            12 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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                            • Automatically Open Query

                              In SQL Search when you double click on an SP it should open it straight away in a new query window. This will eliminate the current need to first double lick to select in object explorer and then right click to modify.

                              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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                              • Add a checkbox to turn on or off the ability to search all system related objects, i.e. tables, stored procs., functions, etc...

                                This would be helpful to find all DM related views or all Stored Procs. related to jobs.

                                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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                                • add configurable keyboard shortcut

                                  add configurable keyboard shortcut

                                  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  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Filter By Reference Type

                                    It would be very useful to be able to filter results by the *type* of reference made.

                                    For instance, find all the occurrences of a particular table, where there are records being inserted to it.

                                    This would be especially helpful for objects where there are many references and sorting through them all manually becomes an onerous task.

                                    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  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 12 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  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Current versus available version in SSMS Add-in window

                                        It would be nice to see what version is installed on my PC versus the current version available on the Red Gate site. This could be displayed in the SSMS Add-in window.

                                        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…)
                                          0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Is there a way to search all the tables or some of tables for a piece of data?

                                          Sometimes we need to search all the tables or a set of tables for a piece of data when we exploring an not well-documented database or not well-desigend database or trouble-shooting a complex data issue. Search database content is likely very time-consuming but sometimes it worth the effort.

                                          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  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 6
                                          • Don't see your idea?

                                          Feedback and Knowledge Base