What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 20481 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
Does access use sql?
What is difference between left and right outer join?
What mean sql?
What are aggregate and scalar functions?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Which are the different types of indexes in sql?
What is a primary key? Explain
Is left join same as inner join?
How do you optimize a stored procedure in sql?
How do I upgrade sql?
Does db2 use sql?
Is trigger a stored procedure?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
how to calculate the difference between two dates? : Sql dba
How can you get sql*loader to commit only at the end of the load file? : aql loader
