How to Drop Table from Database using Data Patch Interface in Magento 2 (Method 1)

 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


Comments

Post a Comment

Popular posts from this blog

Add Admin User name and Action name in Order Comment Section through Action Performed from Sales Order Grid in Magento 2

  Step 1:  First, we need to create an “events.xml“ file inside our extension at the following path app\code\Vendor\Extension\etc\adminhtml\ Then add the code as follows. <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">     <event name="sales_order_save_after">         <observer name="sales_order_save_after_comment_history_add"           instance="\Vendor\Extension\Observer\OrderSaveAfter" />     </event> </config> Step 2:  After that, we need to create an “OrderSaveAfter.php” file inside our extension at the following path app\code\Vendor\Extension\Observer\ And embed the code as given below. <?php  namespace Vendor\Extension\Observer;   use Magento\Framework\Event\ObserverInterface; use Magento\Framework\App\RequestInterface; use Magento\Backen...
Read more

How to Update Product Stock Programmatically in Magento 2

 Steps to Update Product Stock Programmatically in Magento 2: Step 1: We need to create a “Data.php” file inside our extension at the following path app\code\Vendor\Extension\Helper\ Now add the code as follows <?php namespace Vendor\Extension\Helper;   class Data extends \Magento\Framework\App\Helper\AbstractHelper {     protected $_productobj;     protected $_stockRegistry;       public function __construct(         \Magento\Framework\App\Helper\Context $context,         \Magento\Catalog\Model\Product $productobj,         \Magento\CatalogInventory\Api\StockRegistryInterface $stockRegistry,      ) {         $this->_productobj = $productobj;         $this->_stockRegistry = $stockRegistry;         parent::__construct($context);     }       public function updateProductStock($pr...
Read more

How to Set and Get Cookie in Magento 2

 <?php namespace Vendor\Extension\Model; class Customcookie {     private $customCookieManager;     private $customCookieMetadataFactory;     public function __construct(         \Magento\Framework\Stdlib\CookieManagerInterface $customCookieManager,         \Magento\Framework\Stdlib\Cookie\CookieMetadataFactory $customCookieMetadataFactory)    {         $this->customCookieManager = $customCookieManager;         $this->customCookieMetadataFactory = $customCookieMetadataFactory;     }     public function setCookie()     {         $customCookieMetadata = $this->customCookieMetadataFactory->createPublicCookieMetadata();         $customCookieMetadata->setDurationOneYear();         $customCookieMetadata->setPath('/');         $customCookieMe...
Read more