Sites Table (Configuration Database)
The Sites table stores site records for sites in the Microsoft Windows SharePoint Services topology.
Warning Modifying the database schema or database structures is unsupported. 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 |
|---|---|---|
| SiteId | uniqueidentifier | Primary key. |
| DatabaseId | uniqueidentifier | Associated database. Foreign key (Databases table). |
| UrlPath | nvarchar | Path to the site. "/" represents the root. |
| LastModified | datetime | Time of last modification to site record. |
| LastModifiedUser | nvarchar | User who last modified site record. |
| LastModifiedServer | nvarchar | Name of the server affected by the modifications. |
| Status | int | Not used in this table. |
| Version | timestamp | Version of the metainfo parameter in the table. This value is incremented when site properties are modified. |
| Properties | ntext | Not used in this table. |