truncate - What is the difference between trucate and delete? -

truncate - What is the difference between trucate and delete? -

my question main difference between?:

truncate table mytable

and

delete mytable

truncate executed using table lock , whole table locked remove records. delete executed using row lock, each row in table locked deletion. truncate removes rows table mean cannot utilize status truncate delete command used remove rows table based on condition.

truncate sql-delete