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.
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
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!
E-commerce has transformed the way consumers shop for products and services and interact with businesses.…
The e-commerce world is constantly in flux. New tech and strategies emerge daily to help…
Hello Magento Friends, In today’s blog, we will discuss adding a header and footer to…
Hello React Native Friends, Building a visually appealing and responsive mobile app is crucial in…
We're thrilled to announce the release of Hyvä Themes 1.3.6 and 1.3.7! These latest updates…
Your e-commerce platform is surging - orders are rolling in, traffic spikes are becoming the…