Q. Which SQL command removes all rows from a table but retains the structure?

A
DELETE
B
TRUNCATE
C
DROP
D
UPDATE
Solution:

TRUNCATE removes all rows from a table while preserving the table structure and constraints.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!