Visual Query Builder Dialog Box (Database Toolbox)

Database Toolbox

Visual Query Builder Dialog Box

Use the Visual Query Builder (VQB) to retrieve data from your database. The VQB imports the data into MATLAB as a structure, numeric array, or cell array depending on the preference you set. Once imported, you can process the data using the MATLAB suite of functions. With the VQB, you can display information retrieved as cell arrays in relational tables, reports, and charts.

Starting the Visual Query Builder

To start the Visual Query Builder, type querybuilder at the prompt in the Command Window. The VQB interface opens.

Features of the Visual Query Builder

Following are the main steps you perform in order (1 through 11) to build and run a query using the VQB. You don't have to perform all the steps for every query; the required steps are noted with an asterisk (*)

1
Select the Data Source from which you want to import data.

2
Select the Tables that contain the data you want to import.

3
Select the Fields whose data you want to import.

4
Use Advanced Query Options to refine the query.

5
View the SQL Statement.

6
Assign a MATLAB Workspace Variable for the query results.

7
Specify Preferences for Queries using the Query menu

8
Execute the query.

9
View the resulting Data.

10
View results in various formats using the Display Menu.

11
Save and load queries using the Query Menu.

1	Select the Data Source from which you want to import data.
2	Select the Tables that contain the data you want to import.
3	Select the Fields whose data you want to import.
4	Use Advanced Query Options to refine the query.
5	View the SQL Statement.
6	Assign a MATLAB Workspace Variable for the query results.
7	Specify Preferences for Queries using the Query menu
8	Execute the query.
9	View the resulting Data.
10	View results in various formats using the Display Menu.
11	Save and load queries using the Query Menu.

Getting Help for the Visual Query Builder

Get help for the Visual Query Builder, or run a demonstration (for Windows only), from the Help menu. You can also get help in many of the VQB dialog boxes by clicking the Help button.

Other Database Functionality

Use Database Toolbox functions to:

Retrieve information from databases if you prefer functions to using the Visual Query Builder.
Export results from MATLAB to databases.
Write MATLAB-based applications that access databases.
Perform other functions not available with the Visual Query Builder.

For information on how to use the functions, see Using Functions in the Database Toolbox and Function Reference.

See Also

Visual Query Builder, which includes comprehensive examples of how to use the Visual Query Builder.

GUI Reference Data Source