How to Programmatically Check Whether a Database Table Contains a Specified Column in Magento 2?

How to Programmatically Check Whether a Database Table Contains a Specified Column in Magento 2

Hello Magento Friends,

Today’s topic is How to Programmatically Check Whether a Database Table Contains a Specified Column in Magento 2? Do have a look at our recently published blog, How to Get User Information Inside of Controller in Magento 2.

While dealing with a database, the developer needs to check whether a particular column is available in a database table or not. This is usually required while applying some logic to the database. Follow the steps to Programmatically Check Whether a Database Table Contains a Specified Column in Magento 2.

Steps to Programmatically Check Whether a Database Table Contains a Specified Column in Magento 2:

Step 1: Navigate to the below path

app\code\Vendor\Extension\Setup\Recurring.php

And add the below code

namespace Vendor\Extension\Setup

use Magento\Framework\DB\Ddl\Table;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;

Class Recurring implements \Magento\Framework\Setup\InstallSchemaInterface
{
    public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
    {
	           $isExist =  $setup->getConnection()->tableColumnExists(
            $setup->getTable(‘Table_Name’),
            ‘Column_Name’
        );
    }
}

Conclusion:

Hence, this way you can Programmatically Check Whether a Database Table Contains a Specified Column in Magento 2. If you have any doubts, ask me in the comment box without hesitation. Do share the solution with your friends and stay updated with us.

Happy Coding!

Previous Article

How Optimized Product Descriptions Help to Rank the Product in Google SERP?

Next Article

What is Google My Business? The Ultimate Guide for Beginners 2024

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 ✨