Find database table used by a List

Question

_{Friday, November 6, 2015 10:55 AM}

Hello,

I need to find the Table name in the sql database which is used by a list in one of our site.

I can't find any tables named like the site.

For example:

http://projekt/PWA/getitems/Lists/ongoing/planed.aspx

This list should get the data from a table. How can i find it?

I tried to use query to list all table which contain column names (names from the list), but no result.

Thanks in advance.

I Hate Mondays

All replies (1)

_{Monday, November 9, 2015 5:16 AM ✅Answered}

Hi Lokids,

From your description, you want to query list data in SQL database.

One important object used in Sharepoint is the List object.  Lists are much like your .NET data grids allowing users to enter data and fill a grid with relevant information.  The information in a list is stored in the UserData table, and the lists themselves are stored in the Lists table.  A list in the database has a GUID representation.  So if you need to create a report with the data inside your list, you can query these two tables to get this data.

More information:

http://weblogs.sqlteam.com/jhermiz/archive/2007/08/15/60288.aspx

Thanks,

Wendy

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].