Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23004 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / mohammed
Guys, Please remember TRUNCATE CAN BE ROLLED BACK.
DELETE TABLE is a logged operation, so the deletion of each
row gets logged in the transaction log, which makes it slow.
TRUNCATE TABLE also deletes all the rows in a table, but it
won't log the deletion of each row, instead it logs the
De-allocation of the data pages of the table, which makes it
faster.
Because TRUNCATE TABLE is not logged, it cannot activate a
trigger.
TRUNCATE can not be Rolled back using logs.
TRUNCATE is DDL Command.
TRUNCATE Resets identity of the table.
DELETE
DELETE removes rows one at a time and records an entry in
the transaction log for each deleted row.
If you want to retain the identity counter, use DELETE
instead. If you want to remove table definition and its
data, use the DROP TABLE statement.
DELETE Can be used with or without a WHERE clause
DELETE Activates Triggers.
DELETE Can be Rolled back using logs.
DELETE is DML Command.
DELETE does not reset identity of the table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain trigger classes i.e. Instead of and after trigger?
Who is the owner of a schema in ms sql server?
what is nonclustered index
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What will happen if a column containing char type data is changed to the nchar data type?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
How to count groups returned with the group by clause in ms sql server?
what is database replication? : Sql server database administration
What happens if the update subquery returns multiple rows in ms sql server?
What are the different type of replication in sql server?
How do I view a trc file?
Explain few examples of stored procedure over triggers?
What is difference between equi join and inner join?
What are security principals used in sql server 2005?
what is the system function to get the current user's user id? : Sql server database administration
