I am attempting to create a Database View derived from Sharepoint List Data in Sharepoint 2010.
Currently to do this I have simply added a new List Item with Unique values, and manually mapped the columns to their corresponding database columns.
For example: FirstName maps to nvarchar20, LastName maps to nvarchar21 ect...
After doing this a couple times I figured there has to be an easier way of determining this mapping without having to go through each column manually to determine where the data is stored in the database.
Is there a simple way of mapping List Columns to Database columns?