Magento 2: Drop Table from Database using Data Patch Interface

Hello Magento Friends,

In the current Magento 2 tutorial,  you will learn about How to Drop Table from Database using Data Patch Interface in Magento 2.

A Data patch is a type of class that has information for data modifications. This helps to add, update, or delete tables easily. 

Related articles – 

• How to Apply Schema Patch in Magento 2?
• How to Add Custom Product Attribute Programmatically using Data Patch in Magento 2

For now, let’s see How to Drop Table from Database using Data Patch Interface in Magento 2.

Steps to Drop Table from Database using Data Patch Interface in Magento 2:

Step 1: Create the RemoveTable.php file inside the Setup folder at the below file path

app\code\Vendor\Extension\Setup\Patch\Data\RemoveTable.php

And add the below code snippet

<?php 

namespace Vendor\Extension\Setup\Patch\Data;

use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\Setup\Patch\DataPatchInterface;

class RemoveTable implements DataPatchInterface
{   
    const CUSTOM_TABLE = 'custom_table';  // enter your table name..
   
    private $schemaSetup;

    public function __construct(
        SchemaSetupInterface $schemaSetup
    )
    {
        $this->schemaSetup = $schemaSetup;
    }

    public static function getDependencies()
    {
        return [];
    }
  
    public function getAliases()
    {
        return [];
    }
   
    public function apply()
    {
        $installer = $this->schemaSetup;
        $installer->startSetup();

        if ($installer->tableExists(self::CUSTOM_TABLE))
        {
            $installer->getConnection()->dropTable($installer->getTable(self::CUSTOM_TABLE));
        }

        $installer->endSetup();
    }
}

Step 2: Run the below command to remove a table from the database.

php bin/magento setup:upgrade

Conclusion:

Hence, using the above method, you can comfortably Drop Table from Database using Data Patch Interface in Magento 2. If you have any doubts, let me know through the comment part. Share the tutorial with your other Magento friends, and stay in touch with us.

Happy Coding!