Skip to content

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/

SQL Search

Categories

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.

137 results found

  1. Add ability to search for identifiers (tables, columns, indexes, etc.)

    There is currently no way to search for an identifier, e.g., a column name, without also matching text that contains that identifier. For example, if I want to search for a column called ExampleColumn but ignore ExampleColumn2, BadExampleColumn, etc., I could try the "Match whole words only" option. I want it to find all of these:

    SELECT ExampleColumn FROM ExampleTable;
SELECT ExampleColumn, OtherColumn FROM ExampleTable;
SELECT [ExampleColumn] FROM ExampleTable;
SELECT et.ExampleColumn FROM ExampleTable et;
SELECT * FROM ExampleTable WHERE ExampleColumn=3;
SELECT SUM(ExampleColumn) FROM ExampleTable;

    but only the first three are found. Without the whole words option, it would match all…

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  2. sql search stil greyed out, when do you fix this before asking for new features make the old one run well

    sql search stil greyed out, when do you fix this before asking for new features make the old one run well

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. Azure Active Directory - Universal with MFA Authentication for SQL Search

    Would be good that SQL Search authenticated through Azure Active Directory - Universal with MFA.

    SQL Search version: 3.4.2.2567
    Error log:
    [78] ERROR RedGate.SQLSearch.Addin.Tab.DatabaseConnector - Could not load database list
    System.Data.SqlClient.SqlException (0x80131904): Cannot open server "XXXXX" requested by the login. The login failed.
    ...at RedGate.SQLSearch.Addin.Tab.DatabaseConnector.OnlineDatabasesForInstance(String connectionString)
    Error Number:40532,State:1,Class:20
    [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy
    Exception: Exception has been thrown by the target of an invocation.
    ...at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler)

    58 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. Allow searching for users

    SQL Search does not return users as part of the returned results. This could be useful when searching in multiple databases.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. Show results for user-defined types

    Enable users to search for user-defined types. Sometimes there is a certain change and SQL search will not show relevant fields of a user-defined type that matches the search criteria.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. Search SSAS Cube Definitions

    It would be great if you could attach to an SSAS server and search the databases (cubes) for text. I'm mainly interested in the queries used to populate the tables, but I could see it being useful to search for text anywhere in the database.

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  7. Search SSIS Packages

    If an SSIS Catalog is chosen as a database, search the SSIS packages within for the text. I'm not sure how easy it would be to show the results, but even if the results were shown in the XML file format that would be better than nothing.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  8. Exclude expression in search

    Feature to exclude expression in the search.
    Example:
    Search by "Test", but exclude finds where "Test" is part of "tbl_Test"

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. Option to search tables with records only (many of my tables are empty.)

    I would like to be able to check a box to eliminate any tables with no records in them.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  10. Search in job step's database field

    table: msdb.dbo.sysjobsteps
    column: database_name

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  11. Include a dark mode

    Allow users to select to use a dark theme for SQL Search, ideally this would pick up from their settings (if on Windows at least)

    45 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  12. Navigate back and forth between occurrences in search result

    I need a way to move between occurrences of a SQL Search search result (either keyboard shortcut or button/icon).
    Lets say I have a bunch of long stored procedures and the name of a certain table occurs a few times within each of those procedures. I use SQL Search to search for the name of that table.
    Right now, each occurrence of the that table name will be highlighted in the code, but I have to manually scroll through the code to find the highlighted occurrences. This can become a pain if I have to scroll both horizontally and vertically.

    …

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  13. Search in extended properties

    Include the possibility to search inside table extended properties, for example if there's a description I would like to be able to find the text inside the description

    3 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Data search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  14. Find with spaces

    Currently if I search for x y (x,space,y), it will return all instances of x or y.
    If I make it "x y" it finds nothing. There are many times when I want to find the coexistence of two very common terms, so having the latter search (or a variation) return results would be helpful.

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Schema search  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  15. Execute option for Stored Procedures.

    Similar to Select Object in explorer. It would select the object and either execute it or create the Execute to New Query in Editor Window. Like the two options available by right clicking the stored procedure from the object explorer.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  16. Save previous search settings.

    Save all of the previous search settings for dropdowns, checkboxes and search text. Keep SQL Search tab open on next launch of SSMS.

    23 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  17. Need option to turn off auto search

    I would like to have the ability to turn off the "auto search" function. Whenever I enter a search phrase, I feel "rushed" to get it entered before the auto-search kicks in. Many times it starts finding results as I'm typing and then does not search again when I complete my typing. At the point I have to force a re-index.

    It would be helpful to be able to turn that off and then pressing Enter or using a separate search button would initiate the search.

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  18. make bottom panel markdown friendly for tables

    When you are looking at table in the bottom panel, it would be nice if you changed the columns and rows ever so slightly. Instead of making the single dash continuous but made the two horizontal lines continuous instead, then, when you copy and paste this into a Markdown file, it will format it properly

    Example

    from...

    [dbo].[foo]

    Column | Datatype | Computed value

    Id | int |

    ...

    to...

    [dbo].[foo]

    Column | Datatype | Computed value
    ----------------------|-------------------|-------
    Id | int |

    ...

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  19. show extended properties in the bottom panel when looking at a table

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  20. Allow to search Azure Managed Instances

    Allow to search Azure Managed Instances

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Graphical User Interface  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
1 3 5 6 7
  • Don't see your idea?