Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24479 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / kalyana chakravarthy
Delete is associated with rollback segments like U can undo
it before committing and U have a choice of deleting a
specific row or rows where as
Truncate is not associated with rollback segments ie U cant
undo it and U cant delete a row/rows of ur choice
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
what is offset-fetch filter in tsql? : Transact sql
Is sql considered coding?
how to get @@error and @@rowcount at the same time? : Sql dba
What is delete command in sql?
What is embedded sql in db2?
What is the left table in sql?
what is the different between now() and current_date()? : Sql dba
What does inner join mean?
what is the difference between union and union all? : Sql dba
What has stored procedures in sql?
What is a record in a database?
What is the usage of sql functions?
How do you modify a trigger?
How much does sql cost?
Compare sql & pl/sql
