Question

what is the difference between a

Delete command and
truncate command ?

please explain me

thanks a lot ​

Answer 1

Answer:

The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log. ... DELETE command is slower than TRUNCATE command

PLEASE MARK AS BRAINLIEST

Answer 2

Answer:

The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log. ... DELETE command is slower than TRUNCATE command.

Congratulations