What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 20313 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / samba shiva reddy . m
DELETE TABLE is a logged operation, so the deletion of each
row gets logged in the transaction log, which makes it slow.
DELETE removes rows one at a time and records an entry in
the transaction log for each deleted row.
DELETE Can be used with or without a WHERE clause
DELETE Activates Triggers.
DELETE Can be Rolled back.
DELETE is DDL command
example :
begin transaction deleteoncondition
select * from emp
Delete * from emp where empid = 1
rollback deleteoncondition
select * from emp
sp_help samba --Table structure
TRUNCATE TABLE 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.
TRUNCATE wont delete the structure of the table.
DROP will delete the structure of the table also.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I uninstall sql server 2014?
What are the new data types are introduced in sql 2000?
Explain transaction isolation levels in sql server?
what is create database syntax? : Sql server database administration
How to see existing views in ms sql server?
What is linked report?
What command do we use to rename a database?
What is tempdb database? : SQL Server Architecture
Does transparent data encryption provide encryption when transmitting data across the network?
What is difference between cte and view?
What are the steps you should follow to start sql server in single-user mode?
What is the use of tempdb? What values does it hold?
System requirements for sql server 2005 express edition?
Differentiate between a having clause and a where clause.
Mention a few common trace flags used with sql server?
