SQL 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,

Resulting table after using this query:

ID	STUDENT_NAME	ADDRESS

Next TopicSQL Delete duplicate Rows