Describe the difference between truncate and delete

Technology CommunityCategory: SQLDescribe the difference between truncate and delete
VietMX Staff asked 3 years ago
  • Delete command removes the rows from a table based on the condition that we provide with a WHERE clause.
  • Truncate will actually remove all the rows from a table and there will be no data in the table after we run the truncate command.