Sharepoint list fields stored in content database?

Question

Hi,

I am trying to find out where data for Sharepoint List Fields are stored in the Content Database.

For example from the AllLists table filtering on the listid i am interested in I can derive the following Field from the tp_ContentTypes column:

<Field Type="CascadingDropDownListFieldWithFilter" DisplayName="Secondary Subject" Required="FALSE" ID="{b4143ff9-d5a4-468f-8793-7bb2f06b02a0}" SourceID="{6c1e9bbf-4f02-49fd-8e6c-87dd9f26158a}" StaticName="Secondary_x0020_Subject" Name="Secondary_x0020_Subject" ColName="nvarchar13" RowOrdinal="0" Version="1"><Customization><ArrayOfProperty><Property><Name>SiteUrl</Name><Value xmlns:q1="http://www.w3.org/2001/XMLSchema" p4:type="q1:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"&gt;http://lvis.amberlnk.net/knowhow&lt;/Value&gt;&lt;/Property&gt;&lt;Property&gt;&lt;Name&gt;CddlName&lt;/Name&gt;&lt;Value xmlns:q2="http://www.w3.org/2001/XMLSchema" p4:type="q2:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"&gt;SS&lt;/Value&gt;&lt;/Property&gt;&lt;Property&gt;&lt;Name&gt;CddlParentName&lt;/Name&gt;&lt;Value xmlns:q3="http://www.w3.org/2001/XMLSchema" p4:type="q3:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"&gt;PS&lt;/Value&gt;&lt;/Property&gt;&lt;Property&gt;&lt;Name&gt;CddlChildName&lt;/Name&gt;&lt;Value xmlns:q4="http://www.w3.org/2001/XMLSchema" p4:type="q4:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"/&gt;&lt;/Property&gt;&lt;Property&gt;&lt;Name&gt;ListName&lt;/Name&gt;&lt;Value xmlns:q5="http://www.w3.org/2001/XMLSchema" p4:type="q5:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"&gt;Secondary&lt;/Value&gt;&lt;/Property&gt;&lt;Property&gt;&lt;Name&gt;ListTextField&lt;/Name&gt;&lt;Value xmlns:q6="http://www.w3.org/2001/XMLSchema" p4:type="q6:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"&gt;Title&lt;/Value&gt;&lt;/Property&gt;&lt;Property&gt;&lt;Name&gt;ListValueField&lt;/Name&gt;&lt;Value xmlns:q7="http://www.w3.org/2001/XMLSchema" p4:type="q7:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"&gt;Title&lt;/Value&gt;&lt;/Property&gt;&lt;Property&gt;&lt;Name&gt;JoinField&lt;/Name&gt;&lt;Value xmlns:q8="http://www.w3.org/2001/XMLSchema" p4:type="q8:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"&gt;Primary&lt;/Value&gt;&lt;/Property&gt;&lt;Property&gt;&lt;Name&gt;FilterField&lt;/Name&gt;&lt;Value xmlns:q9="http://www.w3.org/2001/XMLSchema" p4:type="q9:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"&gt;Content Type ID</Value></Property><Property><Name>FilterOperator</Name><Value xmlns:q10="http://www.w3.org/2001/XMLSchema" p4:type="q10:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"&gt;Show All</Value></Property><Property><Name>FilterValue</Name><Value xmlns:q11="http://www.w3.org/2001/XMLSchema" p4:type="q11:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"/&gt;&lt;/Property&gt;&lt;/ArrayOfProperty&gt;&lt;/Customization&gt;&lt;/Field&gt;

Which table do I need to query to find the data held on this field?

Many Thanks Nav

Answer 1

I'm sure you already know that going to the SharePoint database is unsupported by Microsoft blah blah blah.

But theoretically speaking... I think what you're interested in is the ColName="nvarchar13" part of your XML. I'm pretty sure what you are looking for is stored in the nvarchar13 column in the AllUserData table.