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 is view in sql?
Explain different types of lock modes in sql server 2000?
How to specify the collation for a character data type in ms sql server?
What are the aggregate and scalar functions?
what are the different types of SSRS reports?
How can I get data from a database on another server?
What do you mean by data integrity?
What are the advantages dts has over bcp?
Explain filestream storage of sql server 2008?
What is always encrypted?
why would you call update statistics? : Sql server database administration
What are user-defined functions (udfs) in sql server?
What happens when converting big values to numeric data types?
How to write a query with a right outer join in ms sql server?
what is the system function to get the current user's user id? : Sql server database administration