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. option to ignore comments when searching for a string.

    option to ignore comments when searching for a string.
    I need to search for SP having "with" statements and its picking up tons of SP with the word "with" in comments

    2 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. save groupings of databases

    On my server there are dozens of databases, each project encompasses several at a time. It would be nice to save groupings of databases so that I can select multiple databases that are relevant for a particular project without sifting through a long checklist picking specific databases.

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. Allow Multiple Word Search

    We have over 200 tables and over 1000 stored procedures. I often need to search on two words. The current "Match whole words only" literally searches for "this word", but I often need it to search for all objects that have exactly "this" and "word". When I search try without the "Match whole words only", I end up with a LOT of results that have words that are similar to "this" and "word", but aren't an exact match.
    I've also tinkered with the wildcards, but that only seems to apply to on character at a time. Maybe I'm doing something…

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  4. Have the ability to remove the default of all databases.

    Having the search start automatically with all database is frustrating when you have hundreds of databases on an instance.
    You should be able to initiate the search when you're ready, or stop the one that is currently running.

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. show precision and scale

    Currently, SQL Search does not show precision and scale for numeric/decimal data types. I erroneously thought a column was defined without those specified when I say the SQL Search results for a table I was looking at.

    Please add precision and scale for decimal/numeric columns to the create table display

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. VS 2019 Support

    As VS 2019 Preview is out, we have still been waiting for VS 2019 support

    1 vote
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Please provide "Check For Update" option for "SQL Search" in its help menu separately

    Please provide "Check For Update" option for "SQL Search" in its help menu separately

    16 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  8. How about support for Color Theme's?

    Please add support fpr COLOR THEME'S

    6 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  9. As a user, I want to be able to export (or copy and paste) the found found objects to my text processor

    I would like to be able to use the found objects in other programs (e.g. my text processor/notepad/email)

    5 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  11. 2 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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

    3 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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?

    15 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Flag idea as inappropriate…  ·  Admin →
  18. 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
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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).

    5 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Flag idea as inappropriate…  ·  Admin →
  20. Exact Match

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

    16 votes
    Vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Graphical User Interface  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 9 10
  • Don't see your idea?

Feedback and Knowledge Base