Using SQL

SQL statements can be used to interactively query a database directly from within OpenTunnel Designer .

All SQL statements recognized by the database software are supported, including:

SELECT	Query database tables.
UPDATE	Edit rows in a table.
DELETE	Delete rows.
INSERT	Add new rows.
CREATE TABLE	Define a new table and add it to the database.
DROP TABLE	Delete an existing table.