Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Adding, Changing, and Deleting Data

Adding, Changing, and Deleting Data Next Page

Data modification statements


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

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
Making changes permanent
Canceling changes
Transactions and data recovery
Integrity checking