How to Create Table in Magento 2

Magento 2 offers a mechanism to create database tables, modify existing ones, and add data into them.

You can create a new database table by InstallSchema in Magento 2.

Create table in Magento 2 to store and retrieve the data. Not only that, but you can also perform various operations such as insert, update and delete on the table data.

Moreover, it can be used for checking the login credentials.

Check the below steps to programmatically create table in Magento 2. You can use this method when creating a custom module in Magento 2.

Steps to Create Table in Magento 2:

1. Create InstallSchema.php at app\code\Meetanshi\Extension\Setup
   
   <?php namespace Meetanshi\Extension\Setup; use Magento\Framework\Setup\InstallSchemaInterface; use Magento\Framework\Setup\ModuleContextInterface; use Magento\Framework\Setup\SchemaSetupInterface; use Magento\Setup\Exception; class InstallSchema implements InstallSchemaInterface { /** * {@inheritdoc} * * @SuppressWarnings(PHPMD.ExcessiveMethodLength) */ public function install(SchemaSetupInterface $setup, ModuleContextInterface $context) { $installer = $setup; $installer->startSetup(); try { $table = $installer->getConnection()->newTable( $installer->getTable('extension') )->addColumn( 'id', \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER, null, ['identity' => true, 'nullable' => false, 'primary' => true], 'Record Id' )->addColumn( 'name', \Magento\Framework\DB\Ddl\Table::TYPE_TEXT, 255, ['nullable' => false], 'Name' )->addColumn( 'email', \Magento\Framework\DB\Ddl\Table::TYPE_TEXT, '255', ['nullable' => false], 'Email' )->addColumn( 'telephone', \Magento\Framework\DB\Ddl\Table::TYPE_TEXT, '255', ['nullable' => false], 'Telephone' )->addColumn( 'created_at', \Magento\Framework\DB\Ddl\Table::TYPE_TIMESTAMP, null, ['nullable' => false, 'default' => \Magento\Framework\DB\Ddl\Table::TIMESTAMP_INIT], 'Created At' )->addColumn( 'update_time', \Magento\Framework\DB\Ddl\Table::TYPE_TIMESTAMP, null, ['nullable' => false, 'default' => \Magento\Framework\DB\Ddl\Table::TIMESTAMP_INIT_UPDATE], 'Updated At' )->setComment( 'Data Table' ); $installer->getConnection()->createTable($table); $installer->endSetup(); } catch (Exception $err) { \Magento\Framework\App\ObjectManager::getInstance()->get('Psr\Log\LoggerInterface')->info($err->getMessage()); } } }

   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71

   <?php   namespace Meetanshi\Extension\Setup;   use Magento\Framework\Setup\InstallSchemaInterface; use Magento\Framework\Setup\ModuleContextInterface; use Magento\Framework\Setup\SchemaSetupInterface; use Magento\Setup\Exception;   class InstallSchema implements InstallSchemaInterface {     /**      * {@inheritdoc}      *      * @SuppressWarnings(PHPMD.ExcessiveMethodLength)      */     public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)     {         $installer = $setup;           $installer->startSetup();         try {             $table = $installer->getConnection()->newTable(                 $installer->getTable('extension')             )->addColumn(                 'id',                 \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,                 null,                 ['identity' => true, 'nullable' => false, 'primary' => true],                 'Record Id'             )->addColumn(                 'name',                 \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,                 255,                 ['nullable' => false],                 'Name'             )->addColumn(                 'email',                 \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,                 '255',                 ['nullable' => false],                 'Email'             )->addColumn(                 'telephone',                 \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,                 '255',                 ['nullable' => false],                 'Telephone'             )->addColumn(                 'created_at',                 \Magento\Framework\DB\Ddl\Table::TYPE_TIMESTAMP,                 null,                 ['nullable' => false, 'default' => \Magento\Framework\DB\Ddl\Table::TIMESTAMP_INIT],                 'Created At'             )->addColumn(                 'update_time',                 \Magento\Framework\DB\Ddl\Table::TYPE_TIMESTAMP,                 null,                 ['nullable' => false, 'default' => \Magento\Framework\DB\Ddl\Table::TIMESTAMP_INIT_UPDATE],                 'Updated At'             )->setComment(                 'Data Table'             );               $installer->getConnection()->createTable($table);             $installer->endSetup();         } catch (Exception $err) {             \Magento\Framework\App\ObjectManager::getInstance()->get('Psr\Log\LoggerInterface')->info($err->getMessage());         }     } }

2. Once the extension is created, all the commands are being run. We are creating InstallSchema.php file after executing the extension. Therefore, we have to delete the existing record.To do that, go to table setup_module and search Meetanshi_Extension in the column module and delete the record.Now, run the commands given below.
   
   php bin/magento setup:upgrade php bin/magento setup:static-content:deploy -f php bin/magento cache:flush

   1 2 3

   php bin/magento setup:upgrade php bin/magento setup:static-content:deploy -f php bin/magento cache:flush

   After running these commands, the table ‘extension’ will appear in the database.
   

Done!

If you have a question regarding this post, feel free to ask in the Comments section below.

I would be happy to help you.

Do share the post with Magento Community via social media.

Thank you.