What is the difference between DELETE and TRUNCATE?
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
Why function is used in sql?
How do I find duplicates in a single column in sql?
How do I count rows in sql?
Do stored procedures prevent sql injection?
Explain how to use transactions efficiently : transact sql
How to start oracle sql developer?
What is database sql?
What is server name sql?
What are sql ddl commands?
What is the difference between null value, zero, and blank space?
what is 'mysqldump'? : Sql dba
What is trigger in pl sql with examples?
Can we perform dml on view?
What is difference between left and right outer join?
What is a string data type in sql?