Computer scienceFundamentalsSQL and DatabasesBasics SQLData 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