Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18689 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
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What is a data collection table?
How can we call UDF(User Define Function) using C# code in ASP.net ?
How you can add messages to the nt event log from within a stored procedure?
What is the maximum row of a size?
What is table valued function and scalar valued functions?
How to defragment indexes with alter index ... Reorganize?
What do you understand by replication in sql server?
What stored by the master?
What type of locking occurs during the snapshot generation? : sql server replication
What is the difference between index seek vs. Index scan?
What causes index fragmentation?
Explain different types of collation sensitivity?
What are ddl triggers and types of ddl trigger?
Why is the need for data conversion transformations?
