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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Statement Reference

UltraLite CREATE TABLE statement Next Page

UltraLite DELETE statement


Delete rows from a table in the database.

Syntax

DELETE
[ FROM ] table-name
[ WHERE search-condition ]

Parameters

WHERE clause    If a WHERE clause is specified, only rows satisfying search-condition are deleted. See Search conditions in UltraLite.

Additionally, the WHERE clause does not support non-deterministic functions (like RAND) or variables. Nor does this clause restrict columns; columns may need to reference another table when used in a subquery.

Remarks

The DELETE statement deletes all the rows that satisfy the search condition from the named table.

The way in which UltraLite traces row states is unique. Be sure you understand the implication of deletes and row states. See UltraLite row states.

See also
Example

The following statement removes employee 105 from the database.

DELETE
FROM employee
WHERE emp_id = 105

The following statement removes all data prior to the year 2000 from the fin_data table.

DELETE
FROM fin_data
WHERE year < 2000