locked
storage of list & library. RRS feed

  • Question

  • SPListCollection contains both the document libraries and lists. I am wondering does list & library both store on same table in DB.

    Regards Restless Spirit

    Sunday, January 5, 2014 4:22 PM

Answers

  • you can think of the document library content type is inherited from List , they are all lists 

    and the page library is a document library 

    if you check the SPDocumentLibrary class it's inheriting from the SPList  the document library is a list plus some other additional properties and attributes 

    public class SPDocumentLibrary : SPList

    Hope that helps|Amr Fouad|MCTS,MCPD sharePoint 2010

    Sunday, January 5, 2014 4:59 PM

All replies

  • if you check the content database you will find the below tables

    AllLists (stores all Lists) for the field values check the table "NameValuePair

    for the documents it's stored in below docs 

    AllDocs

    AllDocVersions

    DocStreams (this table contains the actual document file in a column called content


    Hope that helps|Amr Fouad|MCTS,MCPD sharePoint 2010

    Sunday, January 5, 2014 4:39 PM
  • if it is then why both list and library is represented by same object that is SPList?

    Sunday, January 5, 2014 4:44 PM
  • you can think of the document library content type is inherited from List , they are all lists 

    and the page library is a document library 

    if you check the SPDocumentLibrary class it's inheriting from the SPList  the document library is a list plus some other additional properties and attributes 

    public class SPDocumentLibrary : SPList

    Hope that helps|Amr Fouad|MCTS,MCPD sharePoint 2010

    Sunday, January 5, 2014 4:59 PM