When You need to add a new field in the existing table, you need to create UpgradeSchema.php file in Setup folder of your module.
We add new address field in our existing table by below way, We have just create a database table in the previous post, Create Database table in Magento 2
<?php
namespace Rbj\Training\Setup;
use Magento\Framework\Setup\UpgradeSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\DB\Ddl\Table;
class UpgradeSchema implements UpgradeSchemaInterface
{
/**
* {@inheritdoc}
*/
public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
{
if (version_compare($context->getVersion(), '1.0.1') < 0) {
$connection = $setup->getConnection();
$connection->addColumn(
$setup->getTable('create_form'),
'address',
[
'type' => \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
'length' => 255,
'nullable' => true,
'default' => '',
'comment' => 'Address field'
]
);
}
}
}
Run php bin/magento setup:upgrade
Now you can check your new address field is display in your create_form table.