Executing SQL

When you have the SQL statements you want in the workspace, you can submit them to the DBMS.

StepsTo execute the SQL:

  1. Click the Execute button, or select Design>Execute SQL from the menu bar.

If the SQL retrieves data, the data appears in grid format in the Results view. If there is a database error, you see a message box describing the problem.

For a description of what you can do with the data, see “Manipulating data”.