Table Deleting

Hi,

when I delete a blog on dashboard.
is it database tables delete automaticly?

Thanks,