Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between Delete and Truncate
- 4 Answers
- 8687 Views
- CarrizalSoft Technologies, Geo Research Centre, I also Faced
- E-Mail Answers
Answer Posted / soorai ganesh
DELETE is a logged operation on a per row basis. This means that the deletion of each row gets logged and physically deleted.
You can DELETE any row that will not violate a constraint, while leaving the foreign key or any other contraint in place.
TRUNCATE is also a logged operation, but in a different way. TRUNCATE logs the deallocation of the data pages in which the data exists. The deallocation of data pages means that your data rows still actually exist in the data pages, but the extents have been marked as empty for reuse. This is what makes TRUNCATE a faster operation to perform over DELETE.
You cannot TRUNCATE a table that has any foreign key constraints. You will have to remove the contraints, TRUNCATE the table, and reapply the contraints.
TRUNCATE will reset any identity columns to the default seed value. This means if you have a table with an identity column and you have 264 rows with a seed value of 1, your last record will have the value 264 (assuming you started with value 1) in its identity columns. After TRUNCATEing your table, when you insert a new record into the empty table, the identity column will have a value of 1. DELETE will not do this. In the same scenario, if you DELETEd your rows, when inserting a new row into the empty table, the identity column will have a value of 265.
I believe its enough to you...............
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
‘Order by’ is not allowed in a view how can you sort information from a view?
What does dml stand for?
In which tcp/ip port does sql server run? Can it be changed?
What is function of ROLLUP ?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is de-normalization and what are some of the examples of it?
How efficient you are in oracle and SQL server?
Can we update data in a view?
What are the different types of locks in the database?
Describe different Processing Modes offered by SSRS?
What is a constant or literal in ms sql server?
Is the log file is a part of file group?
What is apply operator in sql?
How do you delete a trigger?
How the authentication mode can be changed?
