DROP vs TRUNCATE vs DELETE

DROP vs TRUNCATE vs DELETE

DROPTRUNCATEDELETE
Remove an entire object from the database1. Remove all rows from a table without logging individual row deletions or firing triggers. 2. Identity sequence reset to its seed valueRemove specific rows from a table based on a condition
DDLDDLDML
Can be rollback
DROP TABLE comments;TRUNCATE TABLE comments;DELETE FROM comments WHERE commentID = 2;