What is difference between TRUNCATE & DELETE?
- 16 Answers
- 39596 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 do I save a sql query?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What are all the different normalizations?
What will you get by the cursor attribute sql%found?
What is autocommit sql?
what happens if you no create privilege in a database? : Sql dba
What is the difference between left outer join and left join?
What is linq to sql?
What is the difference between mdf and ndf files?
What is denormalization in a database?
What is a natural join?
Explain the insert into statements in sql?
What is data control language?
What is write ahead logging in sql server?
What is a sql schema used for?
