Promis.e Help

Using SQL

SQL statements can be used to interactively query a database directly from within Promis.e .

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.