What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 20350 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / protyusha banerjee dawn
Whenever we delete records then they are stored in data
dictionary and can be retrieved later ie by roll back.
but when we truncate then the memory used by the records
which is to be truncated is released and it cannot be
rolled back.
| Is This Answer Correct ? | 24 Yes | 5 No |
Post New Answer View All Answers
which tcp/ip port does sql server run on? : Sql dba
Explain ttitle and btitle.
what is top in tsql? : Transact sql
what is the difference between group by and order by in sql? : Sql dba
How do I create an index in word?
What is record type in pl sql?
How do you update a table in sql?
What is a boolean in sql?
Can we insert data in view?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What's the difference between inner join and left join?
What can sql server reporting services do?
How to process query result in pl/sql?
What type of database is sql?
What is trigger and stored procedure in sql?
