magento1 and magento2 which table to store all the category .so which related table to store data like category and also give the different.
Thank you, Your Faithfully, Mehul Kanjariya
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
As others have mentioned there are many tables used for any entity in Magento because of the use of EAV (entity attribute value). I wouldn't recommend working with the database directly until you understand exactly what is happening when performing any sort of CRUD action on an entity. You can very easily end up with orphaned rows.
Do you only need the names of tables containing category data ??
As Magento uses EAV structure so there can not be only one table holding the data. I have attached the names of various tables below.
You can find listing of all categories in this table "catalog_category_entity"
catalog_category_entity catalog_category_entity_datetime catalog_category_entity_decimal catalog_category_entity_int catalog_category_entity_text catalog_category_entity_varchar catalog_category_product catalog_category_product_index catalog_category_product_index_replica catalog_category_product_index_store1 catalog_category_product_index_store1_replica catalog_category_product_index_tmp catalog_url_rewrite_product_category
** This is for Magento2 for Magento1 you can find almost same names with some different structure, better to directly go into database and have a look by filtering with category name.