UltraLite Database User's Guide
  Dynamic SQL
    Dynamic SQL statements

DELETE statement

Description 

Use this statement to delete rows from the database.

Syntax 

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

Usage 

The DELETE statement deletes all the rows that satisfy the search condition from the named table. If no WHERE clause is specified, all rows from the named table are deleted.

Side effects 

None.

Example 

Remove employee 105 from the database.

DELETE
FROM employee
WHERE emp_id = 105

Remove all data prior to 2000 from the fin_data table.

DELETE
FROM fin_data
WHERE year < 2000