have you ever gotten rid of your dog?

I never thought I would feel like this because growing up I always loved my dogs. But I have the biggest asshole for a dog. He shits every time I leave the house. He pees ON OUR BED, like in spite of us or something. He tears up the backyard from digging. He runs away. I just can't take him anymore. I honestly don't like him. And that's heartbreaking because my kids love our dog. What would you do? The only reason I have him is because my kids love him. But I'm in tears right now because I went to go lay down after an exhausting day and there's dog piss all over my bed.