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

correlation-name   An identifier to use when referencing the table from elsewhere in the statement.

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

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.

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.

• START SYNCHRONIZATION DELETE statement [UltraLite] [UltraLiteJ]
• STOP SYNCHRONIZATION DELETE statement [UltraLite] [UltraLiteJ]

The following statement removes employee 105 from the Employees table.

DELETE
FROM Employees
WHERE EmployeeID = 105;

The following statement removes all data before the year 2000 from the FinancialData table.

DELETE
FROM FinancialData
WHERE Year < 2000;