DELETE vs TRUNCATE: TRUNCATE typically?

Questions

Attempts

Passed

Failed

Likes

Views

Comments

QUESTION

Answer: Removes all rows and resets identity (faster, DDL-like)

TRUNCATE clears the table quickly; DELETE can remove specific rows with WHERE.

Published By

Opinions & Comments

No comments yet.

WAS THIS QUESTION HELPFUL?

Please help us improve by giving us your feedback.

WAS THIS QUIZ HELPFUL?

Related Questions