What is difference between TRUNCATE & DELETE?
- 16 Answers
- 39655 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / jude franco
TRuncate removes all the rows in a table in one go.
Delete deoes it for each row
Truncate does not make entries in a LOG file
Delete makes entries for each row that gets deleted
| Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
how to install mysql? : Sql dba
Can we rollback delete command?
Explain 3 basic parts of a trigger.
Is t sql a programming language?
What is difference between left and right outer join?
Is null operator in sql?
What is record variable?
What is java sql driver?
What is a left inner join?
How is pl sql different from sql?
What does cursor do in sql?
What is the use of count (*) in sql?
What is the sql query to display the current date?
What is the main reason behind using an index?
What is a join query?
