Database Toolbox

Using the Visual Query Builder Versus Functions

These guidelines describe the main differences between the Visual Query Builder and the Database Toolbox functions.

When to Use the Visual Query Builder

Use the Visual Query Builder to:

• Retrieve data from relational databases for use in MATLAB when you are not familiar with the Structured Query Language (SQL).
• Insert data from MATLAB into new records in a database when you are not familiar with SQL.
• Easily build SQL queries and exchange data between databases and MATLAB using a GUI.

The VQB automatically generates and displays the SQL statement or MATLAB statement for the queries it runs. You can directly edit the statements in the VQB. You can also copy and paste the statements you generate using the VQB into MATLAB code that uses Database Toolbox functions.

When to Use Database Toolbox Functions

You can use the Database Toolbox functions to do everything the VQB does and more. Database Toolbox functions offer these additional features:

• Replace data in databases from MATLAB.
• Write MATLAB applications that access databases.
• Perform other functions not available with the Visual Query Builder, for example, accessing database metadata.

Expected Background for Users

System Requirements

© 1994-2005 The MathWorks, Inc.