Are all credit cards and loans insured in Canada or US so that when I die it is payed off .?

I was told last year that my loans and credit cards will be payed off automatically when I die. I was concerned that collection agencies and banks would suck and drain my family when I am dead and have no more blood left for them to suck. I would appreciate people confirming that it is payed off when I die.