My understanding of Hume is that he is not questioning that the sun will rise tomorrow, but the validity of our tendency to assume it will. He does not deny cause and effect relationships. What he is essentially saying is that we have no right to be sure the sun will rise tomorrow. We form habits in our mind that constantly connect cause and effect, and for this reason, the relationship is not universal, but only a construct in our mind.