Export (0) Print
Expand All
2 out of 3 rated this helpful - Rate this topic

UserData Table

The UserData table stores the data that is displayed in the lists.

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_ID int ID of the data.
tp_ListId uniqueidentifier GUID of the list with which the data is associated. Found in the Lists table.
tp_SiteId uniqueidentifier GUID of the SharePoint site to which the data belongs. Found in the Sites table.
tp_Version int Value that indicates the version of the data.
tp_Author int tp_ID from the UserInfo table of the user who entered the data.
tp_Editor int tp_ID from the UserInfo table of the user who last modified the data.
tp_Modified datetime Date and time the data was modified.
tp_Created datetime Date and time the data was created.
tp_Ordering varchar Field that specifies the order for threading Web discussion comments.
tp_HasAttachment bit Value that specifies whether the item has an associated attachment.
tp_ModerationStatus int Value that specifies the status of a list if it is moderated. 0 is approved; 2 is pending; 1 is rejected.
tp_IsCurrent bit Value indicating whether the item is the current item in the issue tracking list.
tp_ItemOrder float Sort criterion for an ordered list.
tp_InstanceID int ID for an occurrence in a Meeting Workspace site that has a recurring event or multiple single events linked to it.
tp_GUID uniqueidentifier GUID value used in full-text search.
tp_Size int Size of the data.
nvarchar1 nvarchar Available field for custom information using the Microsoft SQL Server nvarchar data type.
nvarchar2 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar3 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar4 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar5 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar6 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar7 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar8 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar9 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar10 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar11 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar12 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar13 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar14 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar15 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar16 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar17 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar18 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar19 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar20 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar21 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar22 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar23 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar24 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar25 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar26 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar27 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar28 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar29 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar30 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar31 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar32 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar33 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar34 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar35 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar36 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar37 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar38 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar39 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar40 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar41 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar42 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar43 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar44 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar45 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar46 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar47 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar48 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar49 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar50 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar51 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar52 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar53 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar54 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar55 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar56 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar57 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar58 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar59 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar60 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar61 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar62 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar63 nvarchar Available field for custom information using the SQL Server nvarchar data type.
nvarchar64 nvarchar Available field for custom information using the SQL Server nvarchar data type.
int1 int Available field for custom information using the SQL Server int data type.
int2 int Available field for custom information using the SQL Server int data type.
int3 int Available field for custom information using the SQL Server int data type.
int4 int Available field for custom information using the SQL Server int data type.
int5 int Available field for custom information using the SQL Server int data type.
int6 int Available field for custom information using the SQL Server int data type.
int7 int Available field for custom information using the SQL Server int data type.
int8 int Available field for custom information using the SQL Server int data type.
int9 int Available field for custom information using the SQL Server int data type.
int10 int Available field for custom information using the SQL Server int data type.
int11 int Available field for custom information using the SQL Server int data type.
int12 int Available field for custom information using the SQL Server int data type.
int13 int Available field for custom information using the SQL Server int data type.
int14 int Available field for custom information using the SQL Server int data type.
int15 int Available field for custom information using the SQL Server int data type.
int16 int Available field for custom information using the SQL Server int data type.
float1 float Available field for custom information using the SQL Server float data type.
float2 float Available field for custom information using the SQL Server float data type.
float3 float Available field for custom information using the SQL Server float data type.
float4 float Available field for custom information using the SQL Server float data type.
float5 float Available field for custom information using the SQL Server float data type.
float6 float Available field for custom information using the SQL Server float data type.
float7 float Available field for custom information using the SQL Server float data type.
float8 float Available field for custom information using the SQL Server float data type.
float9 float Available field for custom information using the SQL Server float data type.
float10 float Available field for custom information using the SQL Server float data type.
float11 float Available field for custom information using the SQL Server float data type.
float12 float Available field for custom information using the SQL Server float data type.
float13 float Available field for custom information using the SQL Server float data type.
float14 float Available field for custom information using the SQL Server float data type.
float15 float Available field for custom information using the SQL Server float data type.
float16 float Available field for custom information using the SQL Server float data type.
float17 float Available field for custom information using the SQL Server float data type.
float18 float Available field for custom information using the SQL Server float data type.
float19 float Available field for custom information using the SQL Server float data type.
float20 float Available field for custom information using the SQL Server float data type.
float21 float Available field for custom information using the SQL Server float data type.
float22 float Available field for custom information using the SQL Server float data type.
float23 float Available field for custom information using the SQL Server float data type.
float24 float Available field for custom information using the SQL Server float data type.
float25 float Available field for custom information using the SQL Server float data type.
float26 float Available field for custom information using the SQL Server float data type.
float27 float Available field for custom information using the SQL Server float data type.
float28 float Available field for custom information using the SQL Server float data type.
float29 float Available field for custom information using the SQL Server float data type.
float30 float Available field for custom information using the SQL Server float data type.
float31 float Available field for custom information using the SQL Server float data type.
float32 float Available field for custom information using the SQL Server float data type.
datetime1 datetime Available field for custom information using the SQL Server datetime data type.
datetime2 datetime Available field for custom information using the SQL Server datetime data type.
datetime3 datetime Available field for custom information using the SQL Server datetime data type.
datetime4 datetime Available field for custom information using the SQL Server datetime data type.
datetime5 datetime Available field for custom information using the SQL Server datetime data type.
datetime6 datetime Available field for custom information using the SQL Server datetime data type.
datetime7 datetime Available field for custom information using the SQL Server datetime data type.
datetime8 datetime Available field for custom information using the SQL Server datetime data type.
datetime9 datetime Available field for custom information using the SQL Server datetime data type.
datetime10 datetime Available field for custom information using the SQL Server datetime data type.
datetime11 datetime Available field for custom information using the SQL Server datetime data type.
datetime12 datetime Available field for custom information using the SQL Server datetime data type.
datetime13 datetime Available field for custom information using the SQL Server datetime data type.
datetime14 datetime Available field for custom information using the SQL Server datetime data type.
datetime15 datetime Available field for custom information using the SQL Server datetime data type.
datetime16 datetime Available field for custom information using the SQL Server datetime data type.
bit1 bit Available field for custom information using the SQL Server bit data type.
bit2 bit Available field for custom information using the SQL Server bit data type.
bit3 bit Available field for custom information using the SQL Server bit data type.
bit4 bit Available field for custom information using the SQL Server bit data type.
bit5 bit Available field for custom information using the SQL Server bit data type.
bit6 bit Available field for custom information using the SQL Server bit data type.
bit7 bit Available field for custom information using the SQL Server bit data type.
bit8 bit Available field for custom information using the SQL Server bit data type.
bit9 bit Available field for custom information using the SQL Server bit data type.
bit10 bit Available field for custom information using the SQL Server bit data type.
bit11 bit Available field for custom information using the SQL Server bit data type.
bit12 bit Available field for custom information using the SQL Server bit data type.
bit13 bit Available field for custom information using the SQL Server bit data type.
bit14 bit Available field for custom information using the SQL Server bit data type.
bit15 bit Available field for custom information using the SQL Server bit data type.
bit16 bit Available field for custom information using the SQL Server bit data type.
uniqueidentifier1 uniqueidentifier Available field for custom information using the SQL Server uniqueidentifier data type.
ntext1 ntext Available field for custom information using the SQL Server ntext data type.
ntext2 ntext Available field for custom information using the SQL Server ntext data type.
ntext3 ntext Available field for custom information using the SQL Server ntext data type.
ntext4 ntext Available field for custom information using the SQL Server ntext data type.
ntext5 ntext Available field for custom information using the SQL Server ntext data type.
ntext6 ntext Available field for custom information using the SQL Server ntext data type.
ntext7 ntext Available field for custom information using the SQL Server ntext data type.
ntext8 ntext Available field for custom information using the SQL Server ntext data type.
ntext9 ntext Available field for custom information using the SQL Server ntext data type.
ntext10 ntext Available field for custom information using the SQL Server ntext data type.
ntext11 ntext Available field for custom information using the SQL Server ntext data type.
ntext12 ntext Available field for custom information using the SQL Server ntext data type.
ntext13 ntext Available field for custom information using the SQL Server ntext data type.
ntext14 ntext Available field for custom information using the SQL Server ntext data type.
ntext15 ntext Available field for custom information using the SQL Server ntext data type.
ntext16 ntext Available field for custom information using the SQL Serverntext data type.
ntext17 ntext Available field for custom information using the SQL Server ntext data type.
ntext18 ntext Available field for custom information using the SQL Server ntext data type.
ntext19 ntext Available field for custom information using the SQL Server ntext data type.
ntext20 ntext Available field for custom information using the SQL Server ntext data type.
ntext21 ntext Available field for custom information using the SQL Server ntext data type.
ntext22 ntext Available field for custom information using the SQL Server ntext data type.
ntext23 ntext Available field for custom information using the SQL Server ntext data type.
ntext24 ntext Available field for custom information using the SQL Server ntext data type.
ntext25 ntext Available field for custom information using the SQL Server ntext data type.
ntext26 ntext Available field for custom information using the SQL Server ntext data type.
ntext27 ntext Available field for custom information using the SQL Server ntext data type.
ntext28 ntext Available field for custom information using the SQL Server ntext data type.
ntext29 ntext Available field for custom information using the SQL Server ntext data type.
ntext30 ntext Available field for custom information using the SQL Server ntext data type.
ntext31 ntext Available field for custom information using the SQL Server ntext data type.
ntext32 ntext Available field for custom information using the SQL Server ntext data type.
sql_variant1 sql_variant Available field for custom information using the SQL Server sql_variant data type.
sql_variant2 sql_variant Available field for custom information using the SQL Server sql_variant data type.
sql_variant3 sql_variant Available field for custom information using the SQL Server sql_variant data type.
sql_variant4 sql_variant Available field for custom information using the SQL Server sql_variant data type.
sql_variant5 sql_variant Available field for custom information using the SQL Server sql_variant data type.
sql_variant6 sql_variant Available field for custom information using the SQL Server sql_variant data type.
sql_variant7 sql_variant Available field for custom information using the SQL Server sql_variant data type.
sql_variant8 sql_variant Available field for custom information using the SQL Server sql_variant data type.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.