What is the difference between TRUNCATE, DELETE, and DROP?

Question

can you help me with this question

in progress 0
Akshathadabbara 2025-02-28T15:35:24+00:00 1 Answer 6 views
0

Answer ( 1 )

  1. Aravind
    0
    2025-02-28T15:38:31+00:00
    Reply
    Operation Removes Data? Can Rollback? Affects Structure? Performance
    DELETE Yes, specific rows Yes (with COMMIT) No Slower
    TRUNCATE Yes, all rows No No Faster
    DROP Yes, entire table No Yes (removes structure) Fastest

Leave an answer