Posts

Showing posts from October, 2008

Some Important DataBase Tables in MOSS 2007

The list of some important tables in SharePoint Content Database are : • Sites: This Table holds information about all the site collections for this content database. • Webs: This Table holds information about all the specific sites (webs) in each site collection. • UserInfo: This Table holds information about all the users for each site collection. • Groups: This Table holds information about all the SharePoint groups in each site collection. • Roles: This Table holds information about all the SharePoint roles (permission levels) for each site. • AllLists: This Table holds information about lists for each site. • GroupMembership: This Table holds information about all the SharePoint group members. • AllUserData: This Table holds information about all the list items for each list. • AllDocs: This Table holds information about all the documents (and all list items) for each document library and list. • AllUserData: This table has all the metadata which user