Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23023 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / manub22
–> DELETE:
1. Removes Some or All rows from a table.
2. A WHERE clause can be used to remove some rows. If no WHERE condition is specified, all rows will be removed.
3. Causes all DELETE triggers on the table to fire.
–> TRUNCATE:
1. Removes All rows from a table.
2. Does not require a WHERE clause, so you can not filter rows while Truncating.
3. IDENTITY columns are re-seeded on this operation, if no seed was defined then the default value 1 is used.
4. No Triggers are fired on this operation because it does not operate on individual rows.
Check more differences b/w DELETE & TRUNCATE here: http://sqlwithmanoj.com/2009/02/22/difference-between-truncate-delete-and-drop-commands/
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Relational calculus is what type of language?
What is the difference between ‘having’ clause and a ‘where’ clause?
Explain trigger classes i.e. Instead of and after trigger?
What does COMMIT command do?
Define full outer join in sql server joins?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
Is sql server a database?
What is sql server schema compare? How we can compare two database schemas?
What is a dbms wizard?
How to declare and use cursor variables?
How to get @@error and @@rowcount at the same time?
Why is sql server log file full?
what are cursors? : Sql server database administration
What is the use of “join” in sql server?
Difference between primary key and clustered index?
