What table is product meta title keywords and meta discription?

[sparxx]

What table is the following?

product title

product meta title

product meta keyword

product meta description

The table db_catalogrule_product became empty after a mass 500. i restored it but i want to at least salvage a few days work if possible. FYI Lesson to you: Download your DB everyday manually that you work on it.

[sparxx]

db_catalog_product_entity_varchar??

[sparxx]

Also I did not see how to change my avatar. I can't stand being a squishi.

[PankajS_Magento]

Hi @sparxx 

Magento 2 use following table to store the information related to the metadata.

1. catalog_product_entity
2. catalog_product_entity_text
3. catalog_product_entity_varchar

and these are the Main table which define the entity attributes and entity types:

1. eav_attribute
2. eav_entity_type

You can check these tables for the values of above listed fields.

I hope it will help you.

Thanks
--
If my answer is useful, please Accept as Solution & give Kudos

Thanks

[ppareek]

As per data type, Magento 2 store the values in table.

- name (Type: varchar)
- meta_title (Type: varchar)
- meta_description (Type: varchar)
- meta_keyword (Type: text)

'varchar' attributes type values saved in `catalog_product_entity_varchar` table.
'text' attributes type values saved in `catalog_product_entity_text` table.

Product entity main Table is `catalog_product_entity`.

You can use the Below SQL to check data for one Product into CSV file.

SELECT attribute_code, value FROM catalog_product_entity_varchar LEFT JOIN eav_attribute ON catalog_product_entity_varchar.attribute_id = eav_attribute.attribute_id WHERE entity_type_id='4' and attribute_code IN ('name', 'meta_title', 'meta_description') AND row_id IN (SELECT entity_id FROM catalog_product_entity WHERE sku = '{{SKU}}');

Replace placeholder '{{SKU}}' with product SKU.

Same way you need to check in `catalog_product_entity_text` table for meta_keyword attribute.

Hope this help !!