Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 0 down vote favorite

I´m searching for informations about the SharePoint 2010 Database.

Are there infomations about the different tables/views etc.? I don´t found any documents about the SharePoint 2010 Databases on msdn etc. only for 2003 and 2007.

share|improve this question
What's your goal for accessing the database? You should be able to do everything through existing SP tools and resources. – David Lozzi Dec 1 '11 at 14:36
You should only need to check the databases if something is seriously wrong. – EStruyf Dec 1 '11 at 15:29
I'm +1'ing this thing because there's nothing about accessing the databases in the FAQ and because it is an extremely common question. – shufler Dec 1 '11 at 19:01
1  
To gain further personal knowledge about how the platform works and database design in general, I see nothing wrong with learning how the database works - as long as you know that changing ANYTHING renders your environment unsupportable. By anyone. – James Love Dec 1 '11 at 20:32
Thanks for your comments! I´m studying Computer Science and working part-time at a IT company. At the moment I´m searching for an way to generate different reports from the environment. A colleague tells me, that maybe I can found useful informations in the WSS-Logging Database. So I start searching for informations about SharePoint database schema and I found nothing! Thats the reason for this question! By the way... I don´t want to change/direct access the production database! – LaPhi Dec 1 '11 at 22:37

3 Answers

up vote 4 down vote

All queries against SharePoint data should be done through the SharePoint Object Model or Web Services. Creating solutions that access the database directly will result in an unsupported installation of SharePoint.

Though you have nothing preventing you from doing direct SQL queries, you will not get any support on this site for doing anything that will make your farm unsupportable by Microsoft.

share|improve this answer
up vote 2 down vote

You'll likely want the SharePoint Products and Technologies Protocol Documentation. These contain descriptions about the database structure, including table schema, sprocs, and so forth... Along with a lot of other information. And as everyone else has noted, making changes is, for the most part, unsupported. Check out KB841057 for more information on that.

share|improve this answer
up vote 1 down vote

Maybe you can start from here: http://msdn.microsoft.com/en-us/library/dd587562(v=office.11).aspx

But let me remind you, modifying the tables directly is risky and is not supported.

share|improve this answer
Thank you for your comment! But your articel is about the SharePoint 2003 Database Tables. I think it is not the same Database Schema in 2010 – LaPhi Dec 1 '11 at 13:50
2  
AFAIK there is not a published document about SharePoint 2010 db structure and database has not changed much since 2007. Here is a more complete reference msdn.microsoft.com/en-us/library/dd358229(v=PROT.13).aspx – Élodie Petit Dec 1 '11 at 14:22
2  
Actually, the table schemas change all the time. CUs are known to change table names, column names, stored proceedures, etc. Just a recent example: SP2010 SP1 changed the dbo.Sites table in the content database to dbo.AllSites. This is a primary reason why modifying the databases is unsupported, because you can't be sure your changes will conflict with a future update. – shufler Dec 1 '11 at 18:56
1  
Sites still exists as a View for backward compatibility. – James Love Dec 1 '11 at 20:33

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.