Question:medium
Which SQL command is used to remove all rows from a table without deleting the table structure?
Which SQL command is used to remove all rows from a table without deleting the table structure?
Show Hint
Think of it this way: DELETE is like erasing lines in a notebook, TRUNCATE is like ripping out all the pages but keeping the cover, and DROP is like throwing the whole notebook in the trash!
Updated On: May 14, 2026
- DELETE
- DROP
- TRUNCATE
- REMOVE
Show Solution
The Correct Option is C
Solution and Explanation
Was this answer helpful?
2
Top Questions on SQL
- Solve the following query:
- What is the output of the SQL statement?
SELECT MID('CUET2024',2,5)? - SQL applies conditions on the groups through ________ clause after groups have been formed?
- Consider the following two tables emp1 and emp2:
emp1 Id Name 1 Amit 2 Punita What is the output of the following query?emp2 Id Name 1 Punita 2 Anand
SELECT name from emp1 minus SELECT name from emp2; - Want to practice more? Try solving extra ecology questions todayView All Questions