Truncate Delete drop

The truncate transaction cannot be rolled back, And the delete transaction can be rolled back. Truncate is similar to delete statements without where statements. Because truncate uses less system and transaction logs, the efficiency is much higher than the delete statement of a row.

Truncate deletes the table content, releases the table content, and does not delete the table structure definition.

Delete deletes table content, does not release table space, and does not delete table structure definitions.

Drop Delete table content, release table space, and delete table structure definitions.

Truncate Delete drop