Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 23026 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
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
When columns are added to existing tables, what do they initially contain?
How to backup encryption key ?
Is it possible to call a stored procedure within a stored procedure?
What is the maximum size of sql server database?
What is the difference between Triggers and Stored Procedure?
What does asynchronous call backs means?
What is normalization 1nf 2nf 3nf?
how many bits ip address consist of? : Sql server database administration
Explain the different index configurations a table can have?
Explain the properties of the relational tables?
Explain full-text query in sql server?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What are rest-style architecture's?
Explain what is the function of sql server agent windows service?
