ApexSQL Search FAQ
General
For a list of general FAQs about ApexSQL add-ins, please see ApexSQL add-ins general FAQs
SSMS and Visual Studio support
Microsoft SQL Server Management Studio 2012 and higher
Please note: You can use the latest full-featured backwards compatible SQL Server Management Studio for free. Click here
Search
With Text search feature can be search for text within database objects (including object names), data stored in tables and views (even encrypted ones)
The full list can be founded under the Objects combo box of the Object search pane:
Yes, search history allows users to repeat the exact used search, including the search phrase and the specified search options in a single click:
Yes, The Object search and Text search features has the option to quickly identify the desired results by filtering out unwanted results using the Filter row option. Right-click on result grid and from the popup menu choose the Filter row command:
Yes, data can be exported in one of the following formats:
- XML
- CSV
- HTML
Yes, to quick find the location, in Object Explorer, of the
object found during
Yes, there are several parameters that you can set to narrow down your search. The search phrase can be adjusted by specifying whether to match (e.g. Exact match, Object name, Object body) to the searched text. Wildcards can also be used e.g. %
ApexSQL Search supports the same wildcards as the LIKE operator in SQL Server.
For more information on this feature, please refer to: Wildcards supported by LIKE (T-SQL)
Yes
For more information on this feature, please refer to: Using regular expressions in ApexSQL tools
No, for example, the result for the search phrase person will be the same as the search which is done with the search phrase PERSON
Renaming
Yes, you can generate a preview and see exactly what will be executed
Yes, you can rename tables, procedures, views, functions, parameters and columns without breaking any dependencies
For more information on this feature, please refer to: How to change an object name without breaking your SQL database
No. Safe rename works on object names only and only one object at a time. Other strings that are found, besides object names, can’t be replaced within the tool
For an example of how to replace all strings in a database with another string see the article Overview of the SQL REPLACE function
Extended property editor
Yes, ApexSQL Search has the Extended property editor feature which allows to quick review, edit or add a new description for SQL Server database object:
For more information on this feature, please refer to: How to use the ApexSQL Search extended property editor