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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Adding, changing, and deleting data


Data modification statements

The statements you use to add, change, or delete data are called data modification statements, also referred to as the data modification language (DML) part of SQL. The three main DML statements are:

  • INSERT statement   adds new rows to a table

  • UPDATE statement   changes existing rows in a table

  • DELETE statement   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 statements above, the LOAD TABLE and TRUNCATE TABLE statements are especially useful for bulk loading and deleting of data.

See also

Permissions for data modification
Transactions and data modification
Making changes permanent
Canceling changes
Transactions and data recovery
Referential integrity