What is the difference between truncate and delete statement?

Answers were Sorted based on User's Feedback



What is the difference between truncate and delete statement?..

Answer / valarmathi

truncate delete all records from the table and it is auto
commit. We can't able to rollback the data after performing
truncate operation.

delete statement delete the specific or all records from
the table. But we can able to rollback the deleted record

Is This Answer Correct ?    8 Yes 1 No

What is the difference between truncate and delete statement?..

Answer / rajiv singh

Truncate deletes all rows from table. But Delete deletes
row/rows by condition.

Is This Answer Correct ?    5 Yes 0 No

What is the difference between truncate and delete statement?..

Answer / sreejith s t

Both Truncate and delete deletes the rows from a table .
But we cant use where clause in truncate statement . While
doing delete operation all the deleted rows are logged in
the transaction log . It reduces the perfomance . In
truncate operation no transaction logging is happening .
Delete is Autocommited but Truncate is Not .

Is This Answer Correct ?    6 Yes 2 No

What is the difference between truncate and delete statement?..

Answer / ismail hasan

truncate deletes records from a table and while truncating a
table, the table will be dropped from the database and will
again be created automatically. No where clause is
acceptable in truncate statement and one can't restore the
previous data (i.e no rollback is possible) into the table.
It's an efficient process.

Delete statement will delete a particular row(s) on your
choice.

Is This Answer Correct ?    3 Yes 1 No

What is the difference between truncate and delete statement?..

Answer / vasu

Both Truncate and delete deletes the rows from a table .
But we cant use where clause in truncate statement . While
doing delete operation all the deleted rows are logged in
the transaction log . It reduces the perfomance . In
truncate operation no transaction logging is happening .
Delete is Autocommited but Truncate is Not .

Is This Answer Correct ?    1 Yes 0 No

What is the difference between truncate and delete statement?..

Answer / balaji t

Identity counter can be reset in truncate whereas it is not possible in delete.Truncate dont activate trigger whereas delete can be used in triggers.truncate is a DDL command whereas delete is a DML command.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the differences between local and global temporary tables?

0 Answers  


What are trace files?

0 Answers  


What is use of except clause? How it differs from not in clause?

0 Answers  


After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,


what is the difference between table and view

1 Answers  






Where are sql server user names and passwords stored in sql server?

0 Answers  


What is the recursive stored procedure in sql server?

0 Answers  


What is oltp (online transaction processing)?

0 Answers  


How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,


A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  


What is normalization? Explain different forms of normalization?

0 Answers  


How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,


Categories