ASA SQL User's Guide
  Adding, Changing, and Deleting Data

Data modification statements

The statements you use to add, change, or delete data are called data modification statements. The most common such statements include:

• Insert    adds new rows to a table

• Update        changes existing rows in a table

• Delete    removes specific rows from a table

Any single INSERT, UPDATE, or DELETE statement changes the data in only one table or view.

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

Sometimes, the data modification statements are collectively known as the data modification language (DML) part of SQL.

Permissions for data modification
Transactions and data modification