Major difference between DELETE, DROP & TRUNCATE commands
what is the major difference between DELETE, DROP & TRUNCATE commands in database ...?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
VulpesPosted Nov 10, 2013, 12:06 PM
TRUNCATE removes all rows from a datatable, but unlike DELETE, doesn't log the individual deletions. It therefore executes faster and requires fewer resources.
DROP removes the datatable or view itself from the database though it can also remove other stuff such as stored procedures and user defined functions.