DELETE


DEFINITION.
The following "DELETE" statement removes rows from temporary
or permanent base tables, views, or cursor.

EXPLANATION.

The following statement removes from the "Clients" table
everyone whose name begins with W. 


   DELETE FROM Clients
   WHERE name like'w%';


ILLUSTRATION.

The following table called "Clients" shows the work of
"DELETE" statement.

Clients.


Back to SQL statements.