delete all should truncate the sequence id as well