What is Devart dbForge Search for SQL Server?
Find SQL Server is an add-on to Microsoft SQL Server Management Studio that lets you quickly find SQL objects, records, and even text within your databases.
If a database comprises many objects, finding the required table or recalling the names of stored routines is an overwhelming task. When you use Search for SQL Server, you do not have to browse through the SSMS Object Explorer to locate the name of a required column or text within the stored procedure. The database search tool is sure to simplify your life.
- Find fragments of SQL in tables, views, stored procedures, and functions for free
- Use wildcards to substitute any characters in a search string
- Navigate quickly to the object of Search in Object Explorer
- Search across multiple databases and object types
- Perform objects and data Searches in SSMS directly
- Locate tables data according to a search string
- Sort and filter search results
- Configure search filter
Devart dbForge Search for SQL Server Great Features:
Search for SQL Server has two modes: DDL and Data modes. Having chosen the mode, you can then customize your Search by setting up search criteria:
- Match case
- Match the whole word
- Use wild cards
You can quickly search numerous object types across multiple databases simultaneously. This option also allows simultaneous search across multiple database object types:
- triggers, etc.
Search for SQL Server helps save time and extend productivity.
Search Results Management
Search for SQL Server allows you to sort search results according to your needs. With the tool, you can:
the results in a grid for convenient use.
You can find an object by name in a SQL Server database, and Search will identify all objects containing the search query, including the stored routines.
- unique identifiers
The tool will search across both objects' names and bodies.
Search for SQL Server includes the Data Search Mode allowing to locate the table, view, stored procedure, function, trigger, etc., containing the required data and then view this data.
For convenience, the results will be displayed in a grid, where you can check:
- name of an object
- object type
- matches count
You can use wildcards to substitute any character in a search string. With wildcards, you can match zero or more characters, a set of characters included or absent in an object name being searched, etc.
Using the wildcard search feature, you can maximize your search results.
SQL Fragment Search
Using Search for SQL Server, you can find a specified SQL code fragment in tables, views, stored procedures, functions, triggers, etc. For example, searching for a "alter" command will return examples of all code fragments containing the command.
This feature allows you quickly locate an object rather than browsing through a list of objects in the Object Explorer. With this database search tool, you can jump to the found object in Object Explorer with a single click.
Finding anything in the Object Explorer regularly requires a lot of time and eye strain. You can eliminate those using Search for SQL Server and navigate to the found object in a flash.