What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 17345 Views
- I also Faced
- E-Mail Answers
Answer Posted / srisenthil
delete table gives the transactional log where as in
truncate it is not delete the total rows inthe table but
structure of the table has never changed after the
statement is executed it is roll back and the constraints
after the delete statement is remain same where as it is
not in the truncate statement
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Define indexes?
How to drop existing indexes in ms sql server?
How we can compare two database data?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What is DCL?
How to list all user names in a database?
What is the chart in report?
What is data mart? : sql server analysis services, ssas
Explain the benefits of user-defined functions?
What are click through reports?
Do you know concepts and capabilities of sql server?
What happens if null values are involved in boolean operations?
What are the 3 types of schema?
Do you know exporting and importing utility?
Define Business Edition in SQL Azure?
