ApexSQL Search for MySQL – Object search

Applies to:

ApexSQL Search for MySQL

Summary

This article describes how to use the MySQL Object search feature.

Description

With the Object search feature, MySQL 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:

MySQL object search pane

Quick tip icon

Quick tip:

The minimum permissions required to use the MySQL Object search feature:

  • User must have SELECT privileges to be granted on the searched MySQL database

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:

MySQL object search command in the Server Explorer context menu

Another way to launch the MySQL Object search feature is from ApexSQL Search for MySQL main menu in Visual Studio as shown below:

MySQL object search in the ApexSQL Search for MySQL main menu

The search can also be initiated from the ApexSQL Search for MySQL toolbar by clicking on Object search:

MySQL object search command in the ApexSQL Search for MySQL toolbar

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:

MySQL object search info connection message

To overcome this, make sure a database is selected in Server Explorer and the connection to it is established as well.

Search options

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):

MySQL object search types

By selecting the Object names, Object bodies checkboxes, you specify where the searched text should look for results:

Additional options for search MySQL objects

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:

Navigate to server explorer command

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:

MySQL object search history

All results from the result grid can be copied or saved in one of the available formats (XML, HTML, CSV):

Export MySQL objects search results

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:

Filtering MySQL object in the search result grid

FAQ

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 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.

Change Data Source dialog

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.