Databases Table

The Databases table stores content database records that list content databases and the associated settings in a Microsoft Windows SharePoint Services deployment. Each virtual server in the deployment hosts a content database.

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.

Columns

Column name Data type Description
DatabaseId uniqueidentifier Primary key.
VirtualServerId uniqueidentifier Associated virtual server. Foreign key, available from the VirtualServers table.
Name nvarchar Database name.
UserId nvarchar User ID used to connect to the database. Blank for Integrated Windows authentication.
Password nvarchar Password used to connect to the database. Blank for Integrated Windows authentication.
SiteCount int Number of sites in the database.
SiteCountWarning int Number of sites allowed before a warning is generated.
SiteCountLimit int Number of sites allowed.
DatabaseServiceId uniqueidentifier Foreign key, available from the Services table.
LastModified datetime Time of last modification to the database record.
LastModifiedUser nvarchar User who last modified the database record.
LastModifiedServer nvarchar Name of the server affected by the modifications.
Status int Ready or Offline Status (0 is ready, 1 is offline). When offline, no additional sites can be created but existing sites are accessible.
Version timestamp Version of the metainfo parameter in the table. This value is incremented when a site is created and the site count is incremented.
Properties ntext Not used in this table.