On profile delete account is getting deleted but i want the profile to get deleted on deleting account.

I'd wrap doing that programmatically inside a $transaction.

thanks i am doing that currently but from enforcing from DB side would have been great

I think you'd have to set up something like a trigger to do that.

Yes thats what i have done 🙂