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. |