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). |