Just Java™ 2

Deleting Records and Tables

The DELETE statement is used to remove records from a table, and the DROP statement is used to completely remove all trace of a table from the database.

The DELETE statement has this general format:

Format of SQL DELETE statement	Additional information
DELETE FROM tablename    WHERE      colName  someOperator  value   ...   <— can repeat this line, separated by ;                                         AND/OR to further refine which                                             records get deleted

If you forget the “where” clause, all records in the table are deleted! A table with no records still exists in the database, and can be queried, updated, etc. To get rid of all traces of a table (not ...