What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 20195 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
How to delete an existing database user?
What is data compression?
Explain the difference between primary keys and foreign keys?
how you can deploy an ssrs report?
What is sql server replication? : sql server replication
What are the diifferences between the ms sql server vs mysql?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Is resultset an interface?
can you implement data mining in SSRS?
How to get a list of columns in a view using "sys.columns" in ms sql server?
what are acid properties? : Sql server database administration
How do I view a stored procedure in sql server query?
What is pessimistic concurrency?
Explain about local stored procedure?
