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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite SQL reference » UltraLite SQL statements

DELETE statement [UltraLite]

Deletes rows from a table in the database.

Syntax
DELETE [ FROM ] table-name[[AS] correlation-name]
[ WHERE search-condition ]
Parameters
  • 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.

    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 way in which UltraLite traces row states is unique. Be sure you understand the implication of deletes and row states.

Example

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