What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
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
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
What are the differences between char and varchar in ms sql server?
how to overcome kernel isssues
When do you think a developer should use sql server-based cursors?
What is the difference between a function and a trigger?
Please explain go command in sql server?
What is updatable resultset?
Explain the different types of joins?
Define self join in sql server joins?
Can an entity have two primary keys?
What are indexes in sql?
What is store procedure? When do you use?
What is the use of RDBMS?
Explain about Views?
Can we use where clause with group by?