UserInfo Table

The UserInfo table stores information about each user added to the site.

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 ID of the site to which the user belongs. Found in the Sites table.
tp_ID int ID of the user. Incremented numerically.
tp_DomainGroup bit Value that specifies whether the account is a domain group account.
tp_GUID uniqueidentifier GUID for the user.
tp_SystemID varbinary Security token for the user.
tp_Deleted int Value that specifies whether the user was deleted. Note: The user is not removed because the user data is referenced in many other tables.
tp_SiteAdmin bit Value that specifies whether the user is a site administrator.
tp_Login nvarchar Value that specifies the logon name of the user.
tp_Title nvarchar Value that specifies the display name of the user.
tp_Email nvarchar Value that specifies the e-mail address of the user.
tp_Notes nvarchar Notes about the user.