Learn more about Database Toolbox

When to Use Visual Query Builder

On this page…
Tasks You Can Perform Using Visual Query Builder Limitations of Visual Query Builder

Tasks You Can Perform Using Visual Query Builder

You can use Visual Query Builder to:

• Import data from relational databases into the MATLAB workspace by selecting information from lists to build queries.

• Display retrieved information in relational tables, reports, and charts.

• Export data from the MATLAB workspace into new records in a database.

• Easily build SQL queries and exchange data between databases and the MATLAB workspace.

• View and edit SQL statements for queries generated with VQB.

• Automatically generate a MATLAB M-file that consists of Database Toolbox functions that perform queries you built using VQB.

Back to Top

Limitations of Visual Query Builder

• You cannot use Visual Query Builder to replace existing data in a database with data from the MATLAB workspace. Use the update function instead.

• You cannot use Visual Query Builder to export binary data. Instead, use the fastinsert function.

Back to Top

Database Toolbox Functions vs. Visual Query Builder

When to Use Database Toolbox Functions

© 1984-2009- The MathWorks, Inc.    -   Site Help   -   Patents   -   Trademarks   -   Privacy Policy   -   Preventing Piracy   -   RSS