The DELETE Statement
The DELETE statement is used to delete rows from a table. database will update that is why deletion and insertion of data will be done.
DELETE FROM table_name WHERE column_name = some_value
Let's consider a table :
To Delete a Row :
Suppose the row with Lname="sonu" is needed to get deleted
DELETE FROM Person WHERE LName = 'sonu'
To Delete All the Rows : This means that the table structure, attributes, and indexes will be drop.
DELETE FROM table_name