Computer scienceSoftware development foundationsSQL and databasesSQL basicsData Definition Language

Comparison of DELETE and TRUNCATE

Theory

DELETE vs TRUNCATE

Report a typo

Choose the right command for each action.

Choose one option for each row
DELETETRUNCATE
removes row/tuple one by one
locks the entire data page before removing
data deleting process is less resource consuming
uses WHERE clause to remove specific rows/tuples

Create a free account to access the full topic