Watch Out For The SQL Delete Function

The SQL DELETE clause sometimes refers to a single column, but don't assume that field's value is the only one being deleted. The SQL DELETE clause deletes an entire record--it makes no difference if the clause references only a single field. For example:


The above two SQL DELETE commands both do exactly the same thing, they both delete the entire record. Specifing the field such as OrderID does no good, the entire record will still be deleted. So remember, when the SQL DELETE function is used, the entire record will be deleted.

home button   Just click on the button for the Tiproom's Home Page.
Date of last revision: 17 August 2001.