You can add a new column field under the admin_user core table using the db_schema.xml file for Magento 2.3 and the Higher version.
The client has a requirement like, store the current user location based on their geographical area. Continue reading “Add New Column in admin_user table Magento 2.”
Unique Key column in the database table used to avoid the duplication of data in the same column.
Using a unique column key, Table gives guarantees to unique value for the column from the set of records in a table. Continue reading “Create Unique Key Column in db_schema.xml file Magento 2.”
Drop or Remove a database Table in Magento 2 using the Setup folder DataPatchInterface approach.
From Magento 2.3 New Concept Setup Patch Data was introduced. Continue reading “Drop or remove Table from Database using DataPatchInterface Magento 2.”