Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 45859 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
Is sql better than excel?
Explain architecture of sql server notification services?
How to start the command-line sql*plus?
how does a local variable is defined using t-sql? : Transact sql
what is denormalization. : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
How does left join work in sql?
What is delete command in sql?
What does bitemporal mean?
Why procedure is used in sql?
what are all different types of collation sensitivity? : Sql dba
Is it important to partition hard disk?
what is the difference between nested subquery and correlated subquery?
How is a PL/SQL code compiled?
How does sql store data?
