DELETE statement [UltraLite]

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

SQL Anywhere 12.0.1 » UltraLite - Database Management and Reference » UltraLite SQL reference » UltraLite SQL statements

DELETE statement [UltraLite]

Use this statement to delete 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

See also

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;

Discuter à propos de cette page dans DocCommentXchange.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1