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


Deletion of data using DELETE

Simple DELETE statements have the following form:

DELETE [ FROM ] table-name 
WHERE column-name = expression

You can also use a more complex form, as follows:

DELETE [ FROM ] table-name 
FROM table-list 
WHERE search-condition
 WHERE clause
 FROM clause
 See also
 See also

Deletion of all rows from a table