DROP, TRUNCATE and DELETE Difference

Three Ways to Remove Data

The Difference

Examples

DELETE FROM students WHERE marks < 33;  -- some rows
TRUNCATE TABLE students;                -- all rows, keep table
DROP TABLE students;                    -- table gone

Summary

• DELETE = selected rows (with WHERE), can rollback.
• TRUNCATE = all rows, keeps structure, faster.
• DROP = removes the table entirely.

Data हटाने के तीन तरीके

अंतर

Examples

DELETE FROM students WHERE marks < 33;  -- कुछ rows
TRUNCATE TABLE students;                -- सारी rows, table रखें
DROP TABLE students;                    -- table गायब

सारांश

• DELETE = चुनी rows (WHERE के साथ), rollback हो सकता है।
• TRUNCATE = सारी rows, structure रखता है, तेज़।
• DROP = table पूरी तरह हटा देता है।