Step1: Uninstall module:
php bin/magento module:disable <ExtensionProvider_ExtensionName> –clear-static-content
php bin/magento setup:upgrade
cd app/code/<ExtensionProvider>/ rm -rf <ExtensionName>
Step 2: Remove table database :
bss_sitemap
bss_seo_report
bss_redirects
bss_meta_template
Step 3: Remove column: delete all the tables which are added
ALTER TABLE cms_page DROP COLUMN main_keyword, DROP COLUMN seo_h1_title ,DROP COLUMN custom_attribute ,DROP COLUMN custom_attribute ,DROP COLUMN meta_keywords ,DROP COLUMN meta_description;
Step 4: Remove setup on the table setup_module:
DELETE FROM setup_module WHERE module='<Vendor>_<Module>'
Step 5: Remove attribute:
delete from eav_attribute where attribute_code =’seo_h1_title’;
delete from eav_attribute where attribute_code =’custom_attribute’;
delete from eav_attribute where attribute_code =’seo_canonical_tag’;
delete from eav_attribute where attribute_code ='excluded_html_sitemap';
delete from eav_attribute where attribute_code =’excluded_meta_template’;
delete from eav_attribute where attribute_code =’priority_id’;
delete from eav_attribute where attribute_code =’excluded_alt_text’;
delete from eav_attribute where attribute_code =’main_keyword’;
delete from eav_attribute where attribute_code =’excluded_xml_sitemap’;