So a DELETE would check if there were any rows still referencing the parent table, but a TRUNCATE can not and would therefore fail? even though we have cleared the child table already.

Got to go home now, but will try it out soon.

Thanks for the question. I always thought it would be easy to reset primary keys by doing a TRUNCATE on the tables.