SQL Delete Command

SQL Delete

DELETE Query is used to Delete rows from Database Table. When executing a delete statement for certain records only the WHERE clause is also required. This will determine which records to delete, otherwise all records on the table will be deleted.

 

SYNTAX:
DELETE FROM nameoftable;

 EXAMPLE:
DELETE FROM items;

 

DESCRIPTION:
DELETE query is used to delete all records from a table. We can also delete some specific records by using WHERE condition with DELETE.

For example

DELETE FROM items WHERE ItemID=1;