Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18699 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
What is the difference between grant and with grant while giving permissions to the user?
How to access the deleted record of an event?
Which language rdl files made of?
what is sql server? : Sql server database administration
System variable and temporary variables
What are relationships and mention different types of relationships in the dbms
Write a SQL query to make a column as unique?
Explain different types of locks in sql server.
What is the importance of three tier architecture?
What are the different types of collation sensitivity in sql server?
What is change tracking in sql server?
What is data block and how to define data block size?
What is field with example?
How to define and use table alias names in ms sql server?
What is collation sensitivity?
