CTE vs Temp Table

 

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