What is difference between TRUNCATE & DELETE?
- 16 Answers
- 39567 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
How is a process of pl/sql compiled?
Explain foreign key in sql?
What are sql commands?
What is meant by truncate in sql?
Explain the difference between rename and alias?
What is primary key and foreign key with example?
Does mysql_real_escape_string prevent sql injection?
What is information schema in sql?
What are the different types of database management systems?
What is sqlite used for?
What is the location of pre_defined_functions.
What does sign mean sql?
What is a ddl command?
Is primary key always clustered index?
Write the alter statement to enable all the triggers on the t.students table.
