Printer Friendly Version      Send     
Click to Rate and Give Feedback
MSDN
MSDN Library
Web Development
Server Technologies
SDK Documentation
Platform
Reference
Databases
Tables
 Database Tables
 
Database Tables

The following is a list of database tables used in a Microsoft Windows SharePoint Services topology.

Warning  Modifying the database schema or database structures is not supported. Changes that you make to the database contents may be overwritten when you install updates or service packs for Windows SharePoint Services, or when you upgrade an installation to the next product version.

Configuration Database Tables

NameDescription
AntiVirusVendorsAntivirus software vendors.
CustomTemplatesTemplates that appear in the global templates list (template picker).
DatabasesContent databases and associated settings.
GlobalsSettings that apply to all sites on the physical server within a Windows SharePoint Services topology.
InstalledWebPartPackagesWeb Part Packages that are available to the virtual server.
ServersPhysical computers in the Windows SharePoint Services topology.
ServicesServices such as database, Web, and mail services that are included in the Windows SharePoint Services topology.
SitesSites in the Windows SharePoint Services topology.
VirtualServersVirtual servers and their associated settings.
WebPartPackages Web Part Packages that are installed in a topology.

Content Database Tables

NameDescription
CategoriesAssociations among documents and their assigned areas.
ComMdDocument discussions.
DepsDocument dependencies.
DiskWarningDateDate and time of last warning about disk quota.
DocsDocuments and document folders.
DocVersionsVersion history of documents from document libraries.
EventCacheCache for alerts.
EventLogLog for alerts.
HT_CacheCache of documents transformed for viewing in a Web browser.
HT_SettingsSettings for HTML viewing.
ImmedSubscriptionsAlerts that are set to be sent as soon as the changes occur.
LinksLinks to be recalculated during a site recalculation.
ListsLists in the site.
NavNodesNodes that are displayed in the navigation bars.
PersonalizationPersonalization done to Web Parts.
SchedSubscriptionsAlerts that are set to be sent on a daily or weekly basis.
SiteGroupMembershipMembers of cross-site groups.
SiteGroupsCross-site groups.
SitesSites in the content database.
TimerLockLocking scheme that determines which server locks which database.
UserDataList data.
UserInfoInfo about each user added to the site.
WebCatLinks between Web sites and areas.
WebGroupMembershipList of members of the site groups.
WebGroupsSite groups (such as Administrator, Web Designer) for the site.
WebMembers Members of a site.
WebPartsWeb Parts available for the sites. A view is a Web Part.
WebsSubsites associated with a site.
WelcomeNamesDefault documents for the site.
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker