Delete (SQL)

Gennaro avatar. By: Gennaro
Less than a 1 minute read

Home » Vocabulary » Thing » Delete (SQL)

In the database structured query language, the DELETE statement removes one or more records from a table. A subset may be defined for deletion using a condition, otherwise all records are removed. Some DBMSs, like MySQL, allow to delete rows from multiple tables with one DELETE statement (this is sometimes called multi-table DELETE). Executing a DELETE statement can cause triggers to run that can cause deletes in other tables. For example, if two tables are linked by a foreign key and rows in the referenced table are deleted, then it is common that rows in the referencing table would also have to be deleted to maintain referential integrity.

Join our community
windows report logo

Join our community of over 2 million active users and get the latest and most important Windows content on your email address.

Discussions

Next up

How to fix error 0x8000000b in Mail app once and for all

Johnny Williams avatar. By: Johnny Williams
3 minute read

You’ve got an important email to send, but you receive the error 0x8000000b while trying to send your email. What now? To first understand why […]

Continue Reading

Here’s how to fix Selected boot image did not authenticate error

Emmanuel Johnson avatar. By: Emmanuel Johnson
3 minute read

Selected boot image did not authenticate error message is linked with updates, upgrades and driver updates and likely common on HP computers. Note that this […]

Continue Reading

Surface Hub 2S lands in June with a $9,000 price tag

Rabia Noureen avatar. By: Rabia Noureen
2 minute read

Microsoft announced the Surface Hub 2 almost a year ago and recently shared more details on the product line. Surface Hub 2X will hit the […]

Continue Reading