Question

Which SQL command is used to remove all rows from a table without deleting the table structure?

• A. DELETE
• B. DROP
• C. TRUNCATE
• D. REMOVE

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!

Answer 1

The Correct Option is C

Step 1: Understanding the Concept:
In SQL, there are different Data Manipulation Language (DML) and Data Definition Language (DDL) commands used to manage data and structures.

Step 2: Detailed Explanation:

• DELETE: This is a DML command used to remove rows. However, it is typically slower for removing all rows as it logs each deletion and can be used with a WHERE clause.
• DROP: This command deletes the entire table, including its data and its structure (the schema).
• TRUNCATE: This is a DDL command that removes all rows from a table. It is faster than DELETE because it doesn't log individual row deletions, and it preserves the table structure for future use.

Step 3: Final Answer:
The command used to remove all rows while keeping the structure is TRUNCATE.