DB With DB
SQL: The Language to Live Life
Wednesday, December 31, 2025
DELETE vs TRUNCATE vs DROP
DELETE vs TRUNCATE vs DROP
Feature
DELETE
TRUNCATE
DROP
Rollback
✅ Yes
❌ No
❌ No
Where clause
✅ Yes
❌ No
❌ No
Identity reset
❌ No
✅ Yes
—
Logging
Fully logged
Minimally logged
Removes metadata
No comments :
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments ( Atom )
No comments :
Post a Comment