Data Manipulation Language (DML)

Data Manipulation Language (DML) statements add, change and remove the rows stored in tables and views. In Querona these statements target objects in a virtual database, and the change is carried out on the underlying source through its provider.

Statement	Description
INSERT	Adds one or more new rows to a table or view.
UPDATE	Changes the values of existing rows.
DELETE	Removes rows from a table or view.
MERGE	Inserts, updates or deletes rows in a target in a single statement, based on a source.
TRUNCATE TABLE	Removes all rows from a table in one operation.