Difference between DELETE, TRUNCATE, and DROP?

Short answer: DELETE removes rows (logged, can WHERE, fires triggers). TRUNCATE deallocates pages (minimal logging, resets IDENTITY, needs permissions, almost no WHERE). DROP removes the table object.

Identity reset on TRUNCATE is a favorite follow-up.