What is the difference between delete and truncate statement in SQL Database?

1 answer

Answer

1037826

2026-07-25 20:41

+ Follow

Delete statement deletes only the data from the table but you can apply some condition and only part of the data can be deleted. Truncate empties entire table.

Drop deletes the table itself.

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.