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;

or

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