{"id":456,"date":"2024-08-28T08:50:11","date_gmt":"2024-08-28T08:50:11","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=456"},"modified":"2025-05-27T09:50:02","modified_gmt":"2025-05-27T09:50:02","slug":"delete","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/delete\/","title":{"rendered":"DELETE"},"content":{"rendered":"\n

SQL DELETE Keyword<\/h2>\n\n\n\n

The DELETE command is used to delete existing records in a table.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL DELETE Syntax<\/h2>\n\n\n\n
DELETE FROM table_name\nWHERE condition;<\/pre><\/div>\n\n\n\n
If you omit the WHERE<\/code> clause:<\/p>\n\n\n\n
DELETE FROM table_name;<\/pre><\/div>\n\n\n\n
The first form deletes only the records that match the condition. The second form deletes all rows<\/strong> in the table.<\/p>\n\n\n\n
<\/p>\n\n\n\n
SQL DELETE Deleting Specific Records Example<\/h2>\n\n\n\n
The following SQL statement deletes the patient with the last name 'Garcia'<\/code> from the Patients<\/code> table:<\/p>\n\n\n\n
DELETE FROM Patients\nWHERE last_name = 'Garcia';<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
\n
Note:<\/em><\/strong> Be careful when deleting records in a table. Notice the WHERE clause in the DELETE statement. The WHERE clause specifies which record or records should be deleted. If you omit the WHERE clause all records in the table will be deleted.<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
SQL DELETE Deleting All Rows in a Table Example<\/h2>\n\n\n\n
It is possible to delete all rows in a table without deleting the table. This means that the table structure attributes and indexes will be intact.<\/p>\n\n\n\n
The following SQL statement deletes all rows in the Patients<\/code> table without deleting the table:<\/p>\n\n\n\n
DELETE FROM Patients;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL DELETE Labs<\/h2>\n\n\n\n