Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Delete (SQL)
open-in-new
<p>In the database structured query language (<a href="/facts/SQL/UjQLJcYm">SQL</a>), the DELETE statement is used to remove one or more records from a <a href="/facts/Table_(database)/5INvK1Vd">table</a>. A subset may be defined for deletion using a condition, otherwise all records are removed. Some <a href="/facts/Database/VYcpkevb">database management systems</a> (DBMSs), like <a href="/facts/MySQL/QEEDNBDP">MySQL</a>, allow deletion of rows from multiple tables with one DELETE statement (this is sometimes called multi-table DELETE). </p>