How to delete table from mysql when uninstall extension frommagento 2.2.6?

Question

I have created an extension with the schema. It is installed correctly and tables are created correctly in the database.

But, now I want to uninstall that extension.

But with uninstall, I also want to delete the tables which were created during the installation of the same extension.

is there any way to do this?

Answer 1

For uninstalling the extension, you have to create a Setup/Uninstall.php file.

in that file for uninstall function, add following lines to drop your module table.

public function uninstall(SchemaSetupInterface $setup, ModuleContextInterface $context)
    {
        if ($setup->tableExists('module_table_name')) {
            $setup->getConnection()->dropTable('module_table_name');
        }
    }