What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 16416 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 purpose of optimization?
What is normalization process?
on line cluster can we make if yes tell me the procedure
What is advantage data architect?
Delete duplicate rows without using rowid.
Why do we need normalization?
What is sql injection? How to protect against sql injection attack?
Is sql server is free?
What is cross join in sql server joins?
How to change the system date and time from SQL Plus Terminal ?
How to create a simple user defined function in ms sql server?
What is sql server schema compare? How we can compare two database schemas?
What is the ‘fillfactor’?
What is acid db?
How do I create a stored procedure in sql server?
