Personalization Table

The Personalization table stores any personalization that Web Parts have undergone.

Warning Modifying the database schema or database structures is unsupported. Changes that you make to the database contents may be overwritten when you install updates or service packs for Windows SharePoint Services, or when you upgrade an installation to the next product version.

Columns

Column name Data type Description
tp_SiteId uniqueidentifier GUID of the SharePoint site that includes personalization.
tp_WebPartID uniqueidentifier ID of the Web Part that has the changes. GUID links to the ID in the Web table.
tp_PageUrlID uniqueidentifier Page on which the Web Part is displayed. GUID links to the ID in the Docs table.
tp_UserID int ID of the user.
tp_PartOrder int Value that indicates the location of the Web Part on a Web Part Page.
tp_ZoneID nvarchar Value that indicates the zone where the Web Part is located.
tp_IsIncluded bit Display state that shows whether a Web Part is removed.
tp_FrameState tinyint Frame type of the Web Part.
tp_PerUserProperties image Binary field that holds new properties.
tp_Cache image Cached rendering of a Web Part.
tp_Size bigint Size of the Web Part (included in quota).