title: Sharepoint list fields stored in content database?
body: <p>I am trying to find out where data for Sharepoint List Fields are stored in the Content Database.  </p>
  
  <p>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:</p>
  
  <pre><code>&lt;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"&gt;&lt;Customization&gt;&lt;ArrayOfProperty&gt;&lt;Property&gt;&lt;Name&gt;SiteUrl&lt;/Name&gt;&lt;Value xmlns:q1="http://www.w3.org/2001/XMLSchema" p4:type="q1:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance"&gt;http://extra.orange.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&lt;/Value&gt;&lt;/Property&gt;&lt;Property&gt;&lt;Name&gt;FilterOperator&lt;/Name&gt;&lt;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&lt;/Value&gt;&lt;/Property&gt;&lt;Property&gt;&lt;Name&gt;FilterValue&lt;/Name&gt;&lt;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;
  </code></pre>
  
  <p>Which table do I need to query to find the data held on this field?</p>
  
  <p>Many Thanks
  Nav</p>