Catalog Categories are EAV Entity, There are following below 6 Catalog Categories Entity Tables, where Category details are stored.
catalog_category_entity
catalog_category_entity_datetime
catalog_category_entity_decimal
catalog_category_entity_int
catalog_category_entity_text
catalog_category_entity_varchar
Magento 2 All Database Tables [500 & more Tables]
Which Magento 2 database table store customer’s Email Data
Which Magento 2 Database Table Store Customer Newsletter Data
Which Magento 2 database table store customer’s shipping and billing address
How To Remove Sales Order Data & Customer Data in Magento 2
Which Magento 2 Database Tables Store Customer Rating
Which Magento 2 Database Tables Store Customer Review
Which Magento 2 Database Tables Store Customer Wishlist Products
Which Magento 2 Database Table Store Patches
Which Magento 2 Database Table Store Patches
Which Magento 2 Database Table Store Static Blocks & Its Details
Which Magento 2 Database Table Store CMS Pages & Its Details
Which Magento 2 Database Tables Having All URLs Storage