SQL Delete Table

SQL DELETE TABLE is used to delete the contents of the table.

The syntax for DELETE command is

DELETE FROM table_name;


DELETE * FROM table_name


If you want to remove a specific row then you should use WHERE Condition like as follows:

DELETE FROM table_name [WHERE Condition];


Let us see an example of student table

StudentID Student_Name Address City
1 Nithin Bank Street Hyderabad
2 Bharath Panama Street California


Now apply DELETE on this table

DELETE * FROM Student;


Now if you check table it will be empty as the contents of the table will be deleted