Home » MCQs » SQL MCQs » SQL Statements and Clauses MCQs

What is the clause to delete all rows from the table?

27. What is the clause to delete all rows from the table?

1. SQL DELETE ALL ROWS Table_Name;
2. SQL DELETE ROWS Table_Name;
3. DELETE FROM ALL ROWS Table_Name;
4. DELETE FROM Table_Name;

Answer: D) DELETE FROM Table_Name;

Explanation:

DELETE FROM Table_Name is used to delete all rows from the table.