When you run DELETE, every row will be removed from the table.
TRUNCATE TABLE statement also removes all rows from a table. TRUNCATE TABLE has several advantages over DELETE, when used to remove all rows from a table. TRUNCATE TABLE uses less transaction log space, requires fewer locks, and leaves zero pages for the table.
BUT Delete or Truncate does not remove Objects completely.Use DROP
instead of Delete or Truncate.
use DROP TABLE DEMO instead of Delete or Truncate