ApexSQL Search for MySQL
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:
The minimum permissions required to use the MySQL Object search feature:
To initiate feature, in Server Explorer pane of Visual Studio, select a database for which object is wanted to be searched, right-click on it, and from the context menu, choose the Object search command:
Another way to launch the MySQL and MariaDB Object search feature is from ApexSQL Search for MySQL main menu in Visual Studio as shown below:
The search can also be initiated from the ApexSQL Search for MySQL toolbar by clicking on Object search:
In case that a database is not selected in Server Explorer and the Object search command is clicked, the “Connection is not established” info message will appear:
To overcome this, make sure a database is selected in Server Explorer and the connection to it is established as well.
Under the Object type drop-down box, you can narrow down the search scope by selecting only the object type of interest (e.g. table and table columns):
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.