I have created an extension and created zip file of extension so that I can install it through Magento Connect. When I uninstall my custom extension using Magento Connect it will only delete my extension files and folders but database tables of my extension are not deleted.
I also want to remove my database table of extension. I want all process to be done automatically not by using phpmyadmin and do it manually or writing any upgrade script because What I want when my extension is being used by user so they will not face any issue.