Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25137 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / satyajit patel
DELETE: DML, Manual Commit, Till not committed can be
rollback, can be applied for both row level as well as
table level, can be used in trigger, doesn't release memory.
TRUNCATE: DDL, auto commit, cann't rollback, applied table
level, cann't be used in trigger, releases memory.
In both cases structure remains.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
how can you see all indexes defined for a table? : Sql dba
What is a common use of group by in sql?
What are stored procedures in mysql?
What schema means?
what is 'mysqldump'? : Sql dba
What is sqlite format?
What are different types of statements supported by sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
How to write pl sql program in mysql command prompt?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is the source code of a program?
What is a boolean in sql?
Why do we use sql constraints?
How do I create a sql database?
Is sqlite good enough for production?
