SQL DELETE

The DELETE statement is used to remove records or rows from the table. The DELETE statement includes the name of the table, and the WHERE clause defines the rows to be deleted.

Systax:

DELETE [FROM] {table_name}
[WHERE condition]

Where, table_name is the name of the table from which a row(s) is to be deleted.


Example-1:

DELETE Item

Deletes all the rows from the Item table.

Example-2:

DELETE Item WHERE ItemCode = 'I003'

Deletes a row from the Item table in which the attribute ItemCode is 'I003'