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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Queries and data modification


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.

 See also

Privileges for data manipulation
Transactions and data manipulation
Permanent data changes
Cancellation of changes
Transactions and data recovery
Referential integrity
Addition of data using INSERT
Data changes using UPDATE
Data changes using INSERT
Deletion of data using DELETE