Welcome to Questionaries, where you can ask questions and receive answers from other members of the community.

Let us know at info@questionaries.org

Differentiate between TRUNCATE and DELETE?

5 like 0 dislike
Please tell me

What is difference between TRUNCATE and DELETE?
asked 1 year ago by marck_don (191,010 points)

1 Answer

1 like 0 dislike
 
Best answer
TRUNCATE deletes much faster than DELETE
TRUNCATE
DELETE
It is a DDL statement
It is a DML statement
It is a one way trip,cannot ROLLBACK
One can Rollback
Doesn't have selective features (where clause)
Has
Doesn't fire database triggers
Does
It requires disabling of referential constraints.
answered 1 year ago by daneim (127,080 points)

Related questions

7 like 0 dislike
1 answer
3 like 0 dislike
1 answer
8 like 0 dislike
1 answer