MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Database schema for Sharepoint 2007

  Asked By: Tapasvi    Date: Nov 25    Category: MOSS    Views: 4869

Can someone please let me know where i can get information on the database
schema for Sharepoint 2007. I checked the SDk but dont seem to find it there.



12 Answers Found

Answer #1    Answered By: Lynn Mann     Answered On: Nov 25

Out of curiosity, what do you need the database  schema for? Typically best
practice is to only access information stored within the confines of
SharePoint through the SharePoint API. If you attempt to do otherwise, you
have a good chance of inadvertently wiping something out which will cause
your SharePoint platform to cease to operate properly.

Answer #2    Answered By: Damini Dande     Answered On: Nov 25

I am curious to know where the actual content of a page that i am displaying
on my site is stored.

For example I have Basic page called "Helloworld.aspx" and write text on the
page which says " This is a test to see where the content is stored".

I would like to know where exactly this content of " This is a test to see
where the content is stored" is stored in the database.

In sharepoint  2003 it used to be stored in a column called "Content" in the
dbo.docs table of the content database.

For sharepoint 2007  the table is named as dbo.AllDocs.
I am unable to figure out which column the content is stored because the
structure of the tables is changed for sharepoint 2007.

Hope this answers your query.

Let me know if anyone has an answer to my original question.

Answer #3    Answered By: Addison Peck     Answered On: Nov 25

It looks to me like it's in a child table. If AllDocs.HasStream =1 then
join on AllDocStreams.ParentID = AllDocs.Id? Just guessing - I haven't
tried it. I plan to stay out of Management Studio and learn the
SharePoint API instead (eventually...).

Answer #4    Answered By: Lalit Bhattacharya     Answered On: Nov 25

Yup,your right,.Its stored in the AllDocStreams Table.
but it should be AllDocStreams.Id =AllDocs.Id and AllDocs.HasStream =1

Answer #5    Answered By: Gwendolyn Acosta     Answered On: Nov 25

Though it's not a complete schema, but you will get some understanding
at database  level of which content database is using for each
webapplication, personalsites, and ssp.

If you open back up interface in central administration, you can see the
databases list. It will give database name for each web application.

I don't know about other way of looking database name for each web

Answer #6    Answered By: Kyle Hernandez     Answered On: Nov 25

When i say database  schema ,i am not looking at the database names of the web
applications. I am looking at the actual table structures in the content
database and how exactly the data is stored.

Microsoft has schema  definition for Sharepoint 2003 but i am unable to find
for 2007.

Answer #7    Answered By: Kedar Phule     Answered On: Nov 25

So I'm going to suggest something revolutionary...

Open up SQL server and look.

Answer #8    Answered By: Chanel Gaines     Answered On: Nov 25

This is the link for the 2003 version of database  tables.

Answer #9    Answered By: Timmy Whitney     Answered On: Nov 25

I did look up in the SDK but havent found any.

Answer #10    Answered By: Harihar Sonnad     Answered On: Nov 25

I said if you really want to know, open up SQL Server Management Tools and
open the database  and the tables to view the schema. Be warned though as
Michael mentioned that you're on your own if something breaks.

Answer #11    Answered By: Deven Gajjar     Answered On: Nov 25

I have done that too and I am not able to find the column in AllDocs that
suggests it is the field which contains the actual content of the pages and that
was the reason i am asking for description of the database  tables and fields for
sharepoint 2007.

Answer #12    Answered By: Latisha Schneider     Answered On: Nov 25

I've looked recently as well ...I believe it must have been removed from the
SDK docs.

Also, the MS product group (esp. product support) is getting very hard core
about people mucking with the WSS databases. Checkout this KB article
published on April 6: http://support.microsoft.com/kb/841057/en-us

Basically if you (or a 3rd party product you install) directly touches the
database, you're on your own.

Didn't find what you were looking for? Find more on Database schema for Sharepoint 2007 Or get search suggestion and latest updates.