Tag: What is the difference between DELETE and TRUNCATE commands?

DELETE command is used to remove rows from the table, and the WHERE clause can be used for a conditional set of parameters. Commit and Rollback can be performed after the delete statement.

TRUNCATE removes all rows from the table. The truncate operation cannot be rolled back.