SQL Delete

SQL Delete is used to delete record in table.

Syntax


DELETE FROM table_name WHERE condition;



Take a table Student

StudentID StudentName StudentCity
1 Rahul Chandigarh
2 Karan Mohali
3 Neha Delhi
4 Manpreet Chandigarh
5 Ajay Delhi


Delete Query



DELETE FROM Student;



Above, query delete all the record from table.

Back To Top