Data manipulation statements

The statements you use to add, change, or delete data are called data manipulation statements, which are a subset of the data manipulation language (DML) statements part of ANSI SQL.

The main DML statements are:

INSERT statement Adds new rows to a table or view.
UPDATE statement Changes rows in a set of tables or views.
DELETE statement Removes rows from a set of tables or views.
MERGE statement Adds, changes, and removes specific rows from a table or view.

In addition to the statements above, the LOAD TABLE and TRUNCATE TABLE statements are useful for bulk loading and deleting data.

Data manipulation statements

See also