Truncate removes all data from a table while delete removes specific rows.

• Truncate is faster than delete as it doesn't log individual row deletions

• Truncate resets auto-increment values while delete do...read more