Goldest
Answered On : Feb 20th, 2012
Delete would leave "log" statements about every deleted thing and truncate wont. Hence truncate would be faster.
Login to rate this answer.
Delete would leave "log" statements about every deleted thing and truncate wont. Hence truncate would be faster.
Login to rate this answer.
Aarti helkar
Answered On : Apr 9th, 2012
Detelet is basically used to remove the data from db or from table
but truncate is used to remove data with structure of table.
Login to rate this answer.
Ravinder Lathwal
Answered On : May 4th, 2012
1.We can filter data in delete but in truncate we cant
2.Truncate faster than delete;
3.We can rollback delete but truncate is auto commit.
4.Delete is DML but truncate is DDL.
Login to rate this answer.
Johny
Answered On : May 18th, 2012
Truncate will not delete the structure of the table. That retains the table, but delete every row. The "DROP" command, will delete everything including the structure
Login to rate this answer.
- Truncate faster than delete;
- Truncate apply of whole table but one can filter the records in delete command
- We can rollback delete but truncate is auto commit, Once the data has been truncated the data could not be recovered
- Delete is DML but truncate is DDL.
Login to rate this answer.