Where can I find the lookup relation in the SQL Database?

Feb 22, 2012 at 1:17 PM


first of all thank you for this nice tool. It is quite useful for only storing information in one list on SharePoint and when ever you need it in another list to reference it with the filtered lookup.

As the topic already says, where can I find the lookup relation with regards to the SQL Database?

From my understanding all list items for the whole SharePoint are stored in the database table called dbo.AllUserData.

When taking a deeper look into the items which made use of the filtered lookup I didn't find an ID or something else which would let me make a SQL JOIN to get the data from the referenced list.

Can you please push me in the right direction?

Thanks in advance.