Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 46367 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
What is the purpose of a secondary key?
Why procedure is used in sql?
what is uncommittable transactions? : Transact sql
What is sql catalog?
When can we use the where clause and the having clause?
Write the command to remove all players named sachin from the players table.
Write a unique difference between a function and a stored procedure.
How does an execution block start and end in pl sql?
Why is there a need for sqlcode and sqlerrm variables?
What is the difference between nested table and varray?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Whis is not false in primary key?
How can you tell the difference between an index and a view?
How do I save a sql query?
How can I see all tables in sql?
