This article describes the benefits of using ApexSQL Search options for searching phrases, history, and results.
You can use any text string as a search phrase including strings containing special or Unicode characters. There is no virtually no limit to the length of the search phrase.
The search phrases aren’t case sensitive. For instance, to search for Boston, use boston as the search phrase
In addition to plain text, you can use wildcards in your search. For instance, to find all objects which contain a text starting with the letter M, search for M%.
ApexSQL Search supports the same wildcards as the LIKE operator in SQL Server. For a full list of supported wildcards and their use, visit the See also section
Search history enables you to repeat the exact search you’ve used, including the search phrase and the specified search options in a single click.
Let’s say that you’ve searched for the term admin and selected the Exact match option. The next time you want to perform the same search, simply select admin from the Search text drop-down menu; only the results that exactly match admin will be displayed.
If you search for the same phrase, but change the search options (e.g. select a different database) you will be prompted to update the saved search. If you chose to do so, the saved search options will be overwritten with the new ones
You can quickly identify the results you are particularly interested in by:
- Sorting the result set by column. By default, search results are sorted by Name in a descending order. To change the sort order or sort by a different column, simply click the appropriate column name
- Filtering out unwanted results via the Filter row
In addition to plain text, you can use regular expressions to match the results you need. For example, to show the results found in both AdventureWorks2008 and AdventureWorks20012 databases, select the All databases option from the Database combo box prior to searching; after the results are shown, type 2008|20012 in the Filter row.
ApexSQL Search supports .NET framework regular expressions. For more information on how to search for text using regular expressions, visit the See also section
Wildcards supported by LIKE (T-SQL)
Search text with regular expressions
ApexSQL Search – Text search
ApexSQL Search – Object search
ApexSQL Search – Dependency viewer
ApexSQL Search – Safe rename
November 20, 2014