Please indicate the difference between delete from TableA & truncate TABLE TableA in SQL Server

Please indicate the difference between delete from TableA & truncate TABLE TableA in SQL Server

Answer: Both can be used to delete all records in the table. The difference is that truncate is a DDL operation that moves the HWK so that the HWK value is 0 and does not require rollback segment. And delete is a DML operation that requires rollback segment and takes a long time.

Please indicate the difference between delete from TableA & truncate TABLE TableA in SQL Server