{"id":843,"date":"2023-11-21T18:31:17","date_gmt":"2023-11-21T13:01:17","guid":{"rendered":"https:\/\/magecurious.com\/blog\/?p=843"},"modified":"2025-01-10T18:07:50","modified_gmt":"2025-01-10T12:37:50","slug":"create-new-table-using-declarative-schema-in-magento-2","status":"publish","type":"post","link":"https:\/\/magecurious.com\/blog\/create-new-table-using-declarative-schema-in-magento-2\/","title":{"rendered":"Create New Table using Declarative Schema in Magento 2"},"content":{"rendered":"\n

Hello Everyone,<\/p>\n\n\n\n

In this blog, we will learn about how to Create a New Table using Declarative Schema in Magento 2.<\/p>\n\n\n\n

Magento introduced a new feature from version 2.3 that is the Declarative Schema feature. We can create a new database table using the db_schema.xml file.<\/p>\n\n\n\n

Without wasting your time, let us guide you straight away. Follow the easy step given below to Create a New Table using Declarative Schema in Magento 2.<\/p>\n\n\n\n

STEPS FOR CREATE TABLE USING DECLARATIVE SCHEMA IN MAGENTO 2<\/strong><\/p>\n\n\n

\nStep 1: Create db_schema.xml file\n\napp\/code\/Vendor\/Extension\/etc\/db_schema.xml\n\n<?xml version="1.0"?>\n<schema xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance"\n     xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup\/Declaration\/Schema\/etc\/schema.xsd">\n<table name="magecurious_custom_table" resource="default" engine="innodb" comment="Magecurious Custom Table">\n    <column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"\/>\n    <column xsi:type="varchar" name="book_name" comment="BookName" nullable="false"\/>\n    <column xsi:type="varchar" name="book_description" comment="BookDescription" nullable="false"\/>\n    <column xsi:type="varchar" name="author_name" comment="Author Name" nullable="false" \/>\n     <column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP" comment="CreatedAt"\/>\n    <column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP" comment="UpdatedAt"\/>\n    <constraint xsi:type="primary" referenceId="PRIMARY">\n        <column name="id"\/>\n    <\/constraint>\n<\/table>\n<\/schema>\n\nStep 2: Create db_schema_whitelist.json file\n\nThis file provides history about all tables, columns. It also tells Magento to safely alter the table.\n\nYou can run below command to generate db_schema_whitelist.json file\n\nphp bin\/magento setup:db-declaration:generate-whitelist --module-name=Vendor_Extension\n\nStep 3: Finally run the below commands\n\n$ php bin\/magento setup:upgrade\n\n<\/pre><\/div>\n\n\n
Step 4: Output<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Final Thoughts:<\/strong><\/p>\n\n\n\n
So this was the easiest way which we have told you in this blog. This is how you can Create tables using DB Schema in Magento 2. Hope you liked the blog.<\/p>\n\n\n\n
So quickly go to the comment box and tell me how you like this blog?<\/p>\n\n\n\n
Stay tuned with us on our site to get new updates of Magento.<\/strong><\/p>\n\n\n\n
Thanks for reading and visiting our site.<\/p>\n\n\n
      
          
        How useful was this post?      <\/p>              
        Click on a star to rate it!      <\/p>        
      
                      
  •               <\/i>          <\/li>                  
  •               <\/i>          <\/li>                  
  •               <\/i>          <\/li>                  
  •               <\/i>          <\/li>                  
  •               <\/i>          <\/li>              <\/ul>    <\/div>    
    <\/p>