Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24986 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / debi
1.when we use delete command then the records from the
table is not deleted permanently so that when we further
use rollback command the records are again available in the
table but in case of truncate the data is permenently
deleted from the table.
2.in case of truncate data deletion is faster as compared
to delete
3.
we can't use ant where condition in case if truncate
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do I view a view in sql?
Why trigger is used in sql?
what is recursive stored procedure? : Sql dba
What is the purpose of design view?
How do I upgrade sql?
define sql delete statement ? : Sql dba
What does := mean in pl sql?
How many scalar data types are supported in pl/sql?
Why do we use %rowtype & %type in plsql?
How exception handling is done in advance pl/sql?
How can you know that statistics should be updated?
What are the three forms of normalization?
Does truncate require commit?
what is the difference between union and union all? : Sql dba
What is a parameter query?
