This article describes how to use the MySQL and MariaDB Object search feature.
With the Object search feature, MySQL and MariaDB objects can be searched such as tables, table columns, views, stored procedures, and so on that contain the phrase specified in the Search text box of the Object search pane:
| Quick tip: The Object search feature does not support Temporal Data Tables in MariaDB Server 10.3 and above |
By selecting the Object names, Object bodies checkboxes, you specify where the searched text should look for results:
By using the Navigate to server explorer node command from the context menu of the search results grid, the searched object in a database under the Server Explorer pane can be easily located.
In the search result grid, select an object, right-click and from the context menu, choose the Navigate to server explorer node command. This command will mark that object in a searched database in Server Explorer pane as shown below:
All searched phrases in the past will be preserved in the Search text drop-down-box, which can be handy for the search phrases that are repeated from time to time:
All results from the result grid can be copied or saved in one of the available formats (XML, HTML, CSV):
Additionally, the search result can be narrowed down to quickly identify the desired results by filtering out unwanted results. On top of each column in the result grid, there is a filter icon. By clicking on it, it will open the filter row window with the values from the appropriate column that can be checked/unchecked:
Can I use the Object search feature to search objects in the SQL Server databases?
This add-in is only for searching for objects in MySQL and MariaDB databases. To search objects in the SQL Server databases, the ApexSQL Search add-in can be used.
Can MySQL Object search feature search objects in the MySQL databases on cloud (Amazon RDS, Azure)?
Yes, the Object search feature supports searching objects in MySQL databases that are on Amazon RDS and Azure cloud.
Can I use the MySQL object search feature on MySQL database that uses ODBC Data Source?
No, MySQL object search feature supports only the connection from MySQL for Visual Studio Data Source.
Can ApexSQL Search for MySQL be integrated into SQL Server Management Studio?
No, ApexSQL Search for MySQL only supports integration into Visual Studio 2015 and higher.
Is the Search text drop-down box case sensitive?
No, the result for the search phrase NAME and name will be the same.
