The following database tables are used to store information about web parts:
•CMS_WebPartCategory - contains records representing web part categories.
•CMS_WebPart - contains records representing web parts and their properties.
•CMS_WebPartLayout - stores custom layouts for web parts.
•CMS_WebPartContainer - contains records representing web part containers.
•CMS_WebPartContainerSite - stores relationships between web part containers and sites. Each entry in this table indicates that a specific container may be used on a given site.
Web part instance storage
Data about the content of zones on individual page templates, including web parts and their property configuration, is stored in XML format in the PageTemplateWebParts column of the CMS_PageTemplate table.