Catalog Products are EAV Entity, There are following below 6 Catalog Products Entity Tables, where product details are stored.
[1] – catalog_product_entity
[2] – catalog_product_entity_datetime
[3] – catalog_product_entity_decimal
[4] – catalog_product_entity_int
[5] – catalog_product_entity_text
[6] – catalog_product_entity_varchar
[1] – catalog_product_entity:: stores (SKU, Creation & Update Date) of products
[2] – catalog_product_entity_datetime:: stores (Special From Date) of products
[3] – catalog_product_entity_decimal:: stores product’s price
[4] – catalog_product_entity_int:: stores following below data values
manufacturer
color,
features_bags,
manufacturer,
tax_class_id,
visibility,
is_featured,
material,
pattern,
occassion,
brand,
size
[5] – catalog_product_entity_text::
[6] – catalog_product_entity_varchar:: stores following below data values
image,
meta_description,
meta_title,
name,
thumbnail,
url_key,
url_path,
country_of_origin,
country_of_shipping,
gift_message_available,
hsn_codes,
image,
in_the_box,
meta_description,
meta_title,
name,
options_container,
package_dimensions_breadth,
package_dimensions_height,
package_dimensions_length,
rollover_image,
small_image,
swatch_image,
thumbnail,
unit_sets,
url_key,
url_path,
Magento 2 All Database Tables [500 & more Tables]
Which Magento 2 database tables store Product details
Which Magento 2 database tables store Category details
How To Delete Magento 2 Categories & Products in Magento 2
Which Magento 2 Database Table Store Bundles Product
Which Magento 2 Database Table Having All Catalog (Categories & Products) URLs Rewrite Storage Data
Which Magento 2 Database Tables Store Product Attributes
How To Delete Magento 2 Products
How To Delete Magento 2 Categories
How To Delete Magento 2 Categories & Products in Magento 2
Which Magento 2 Database Table Store Customer Group Price of products
Which Magento 2 Database Table Store Products Special Discount Price