DELETE ALL ROWS

The statement SQL DELETE ALL ROWS is used to delete all rows from the table. If you want to delete all the rows from student table the query would be like,

DELETE FROM STUDENT_NAME;  

Resulting table after using this query: