One Response

Another major difference is that TRUNCATE does not allow foreign keys on the table, you need to drop and recreate any foreign keys.
DELETE on the other hand only requires you to delete from tables in the correct order or use cascading deletes.