Differences between Delete and Truncate Assignment Help

Assignment Help: >> Basics of SQL - Differences between Delete and Truncate

Differences between Delete and Truncate

The subsequent table describes the difference between Truncate and Delete

Truncate                                Delete
Deletes all the records              Can delete all the records or selective rows alone.  
This is a DDL statement            This is a DML statement
Commits Implicitly                   Explicit commit is required and
Hence ROLLBACK
Hence Not possible                   can be used to rollback.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd