SQL Delete Query

SQL DELETE Statement

IN SQL DELETE Query  is used to delete existing records in a table

DELETE Syntax -The Basic Syntax For DELETE table are as Follows

DELETE syntax for delete the specified record from the table

SQL>DELETE FROM table_name WHERE condition;

DELETE Synatx for record all the Column From the table

SQL>DELETE FROM table_name;

Delete A specify Record-

Example

SQL>DELETE FROM Student  WHERE StudentName='Ram;

In above Query it will Delete the student whose name is ram from the Student table .

Delete All Records

Example

SQL>DELETE FROM Customers;

In above Query it will Delete all the Row Present in Student table .it Will Not  delete the table just Delete all the Column.