Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22420 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 partitioning method?
What happens to a statement batch if there is a compilation error?
What is report server project?
Explain about SQLOS?
What is indexing in sql server with example?
What is unique key constraint?
How to view existing indexes on an given table using sp_help?
what is the difference between delete table and truncate table commands? : Sql server database administration
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is sql server programming?
How to check status of stored procedure in sql server?
How to select an exiting database using mssql_select_db()?
What is constraints and its types?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
