Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19092 Views
- I also Faced
- E-Mail Answers
Answer Posted / nageswarao
1.truncate is DDL cmd.where as delete is a DML cmd.
2.truncate is similar to delete command without no
condition.
3.when u use truncate it restructure the table,wthout
bothering of data it deletes entire records.
but,delete is a logged transaction.before delete
records it copies to transaction log.then removes.
4.truncate take less time than delete in execution.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can I work with several databases simultaneously? : sql server management studio
What is the maximum size of a row in sql server?
What is the difference between functions and stored procedures?
Why should you use or avoid select * statements?
Explain the database you used in your final year project?
Difference between report and query parameter.
Explain active/passive and active/active cluster configurations?
What are the benefits of filtered indexes?
What is log shipping?
Can we use where clause with group by?
What are the types of normalization?
What are the grouping functions?
How to return the second 5 rows in ms sql server?
What are .mdf files?
Difference between LEN() and DATALENGTH() in sql server ?
