What is difference between TRUNCATE & DELETE?
- 16 Answers
- 39654 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / ram kumar
1.Both are same but a little bit difference between them
2.Truncate removes all the rows in the table and it cannot
be rolledback bcoz its a DDL
3.Delete removes the particular record u want in the table
and it can be rolledback bcoz its a DML
4.Truncate is Unconditional and Delete is Conditional
Regards,
Ram Kumar...
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is sql entity?
How to create your own reports in sql developer?
how mysql optimizes distinct? : Sql dba
What is data types in sql?
What is tuple in sql?
How can you save or place your msg in a table?
What is scalar and vector?
What is a table?
How do you get column names only for a table (sql server)?
What is normalisation in sql?
How to raise user-defined exception with custom sqlerrm ?
What do you understand by pl/sql cursors?
What is crud sql?
what is datawarehouse? : Sql dba
How does rowid help in running a query faster?
