Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is difference between DELETE & TRUNCATE commands?

April 26, 2017commands delete difference truncate

0

10 Posted

What is difference between DELETE & TRUNCATE commands?

1 Answer

0

10 Posted

Delete: Delete is logged operation. Trigger can fire on the delete operation. Delete can use the where clause. Can be used in foreign key relationship tables and remove the data from the child table if the ON DELETE CASCADE is specified. DELETE Can be Rolled back. DELETE is DML Command. DELETE does not reset identity of the table.