Magento 2: Drop Table from Database using Data Patch Interface

Drop Table from Database using Data Patch Interface M2

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 – 

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!

Previous Article

How to Get Invoice Details by Order Id in Magento 2

Next Article

Is Shopify Customization the Right Move to Beat Competition? Here's All You Need to Know

Write a Comment

Leave a Comment

Your email address will not be published. Required fields are marked *

Get Connect With Us

Subscribe to our email newsletter to get the latest posts delivered right to your email.
Pure inspiration, zero spam ✨