What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 17358 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreedhar
Truncate is DDL command, Delete is a DML command.
Delete operation can be rolled back and in truncate we
can't.
Where caluse can be used in Delete and not in Truncate.
Truncate table less time than delete in execution
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is the difference between index seek vs. Index scan?
How to find the service pack installed? : sql server database administration
What is tabulation?
What sql server means?
What are the different types of normalization?
What is create command?
What is a unique key constraint?
Can a cursor be updated? If yes, how you can protect which columns are updated?
Can we do dml on views?
Explain transaction isolation levels in sql server?
Define master database?
What is the difference between stored procedure and functions?
How to run sql server 2005 books online on your local system?
What are different types of views?
How to create and drop temp table in sql server?
