Execute SQL statement
You can only enter administration commands in this dialogue, such as Grant, Create Table, or Drop Table, and not filter commands. The commands that you can enter depend on the data source, for example, dBASE can only run some of the SQL commands list here.
To run an SQL query for filtering data in the database, use the Query Design View.
Command to execute
Enter the SQL administration command that you want to run.
For example, for a "Bibliography" data source, you can enter the following SQL command:
SELECT "Address" FROM "biblio" "biblio"
For more information on SQL commands, please consult the documentation that came with the database.
Lists the previously executed SQL commands. To run a command again, click the command, and then click Run.
Displays the results, including errors, of the SQL command that you ran.
Runs the command that you entered in the Command to execute box.