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. Allow multiple searches in many search tabs

    Allow multiple searches in many search tabs.
    I want to search two different things and have the search results side-by-side.

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
      • Show column nullability and default value

        When showing results on a table definition, show the nullability defined for it as well as any default value. Now, I see three columns: name, datatype and computed value. Please add two more: Null and Default, preferably in the order: Name, Type, Nullable, Computed, Default

        0 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
        • show constraints and default values, allow jump to column in object explorer

          When Displaying the search results that match a table column, include default value and nullable in the results.

          Additionally allow Select object in Object Explorer to select the matched column.

          3 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
          • Option to exclude disabled jobs

            It would be useful to have the option to exclude disabled jobs from the search.

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
            • Azure Active Directory Authentication for SQL Search

              Would be good that SQL Search authenticated through Azure Active Directory, so I could release this tool to many users on my Azure SQL Databases.
              If not possible, would be nice to choose which SQL account to authenticate instead of my current account.

              25 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
              • Show synonym definition in bottom panel

                When SQL Search finds synonyms, they're only labeled as "other". Please label them Synonyms and show the definition in the bottom panel

                1 vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Stop indexing/searching

                  Sometimes when server is changed it automatically starts Reindex for all databases. Even if one database was selected later, it continue re-indexing and it could be very long. Is it possible to add Stop Reindex button to stop the process?

                  16 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
                  • Navigate between search results by keyboard or click

                    When performing a wide search, i. e. "ORDER BY, chances are that it yields many results in single objects (i. e. an SP). At present, I don't see any means of navigating between the results, like by hitting F3 or clicking "next result" or something alike. Ideally, this would include a setting to affect either a single object or the complete list of search results.
                    It would be more than helpful to have something like that!

                    Cheers,
                    Olaf

                    3 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Search to include schema names

                      It would be very beneficial if I could search for objects with a certain schema across the databases I choose. I.e. SQL Search trigger on letter-sequences in schema names, just as in table or column names.

                      As it is, I can only find those objects if they are referenced elsewhere with their schema given (e.g. a stored procedure or a view will give me a hint that a schema exists in a database in a galaxy, far, far away).

                      3 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
                      • Exact Match

                        Please could you put the "Exact Match" feature back, it was very useful.

                        12 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                        • In the results pane, add highlight notches to scrollbar to indicate search term locations.

                          When I do a search, the results pane that contains the text of the object I currently have selected will highlight the search term within the text, but if the object has a large amount of text, I need to scroll and find it. A notch on the scrollbar, like what Google Chrome does with a find-on-page Ctrl+F search, will help with zeroing in on the term within the object's text.

                          7 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                          • Database selections

                            1) The last dropdown just shows me the alias names I use to connect to databases so I have no idea which user I'm doing the search under which impacts results based on the privilleges. This should clearly show which user it's searching under please.
                            2) I'm sat here right now, I've select 1 database to search against out of 300. Yet my search results coming back (after 20 minutes of waiting) keeps including ALL database. I've closed down the search window and tried again, same result. why?
                            3) Needs to be able to export results from the search window…

                            5 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                            • Ability to PERSIST SETTINGS.

                              Ability to maintain settings between searches. When I switch back and forth and open and close it, it goes back to SEARCH ALL, but when I am working, I am usually focused on something and it's quite painful to have to reset the settings almost every-time., We need a checkbox option to PERSIST SETTINGS.

                              When I am working on something I am usually working in one or two databases but we have 50 databases, I don't need to search all those all the time. I am usually looking for where column names are within tables, I love all the features…

                              3 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                              • In SQL Search, provide facility to stop the search.

                                The search facility doesn't stop even if you close the window and starts again with the same search. It doesn't have any button to stop the search if some inputs are wrong.

                                16 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                • In SQL Search, provide the ability to exclude searching in comments for specified text

                                  Periodically I'll search stored procedure and functions for specific text and I'll get a lot of hits, only to discover that the hit was on a comment.

                                  For example if we're trying to remove a specific piece of code from all stored procedures, a DBA may make a comment "Removed XXX from stored procedure". Providing the ability to "Not search in comments" would provide a true list of areas that contain the offending code.

                                  10 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Header

                                    Display headers when showing results from SPs (ANSI_NULLS, etc)

                                    3 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • In SQL Search results, show the rowcount for tables.

                                      Either provide a column with the table's rowcount or allow a way to filter tables that do not contain rows. This would provide a way to eliminate looking into tables that do not have rows and would save a considerable amount of time when looking for data within tables.

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Add support for distinct search results

                                        Add a checkbox for distinct and if selected list each object the search term is found in ONCE. Instead of having 1,200 entries for 23 distinct objects, I'd then see only the 23 lines.

                                        4 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Pneumonic Search

                                          http://www.sqlsmash.com/ - Search Database Objects
                                          I use this *all the time*... it would be nice if the same feature were a part of the redgate toolset

                                          6 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 9 10
                                          • Don't see your idea?

                                          Feedback and Knowledge Base