URLs (DocMd) Table

The URLs table holds the URLs to all documents in the SharePoint team Web site and all the common document properties. This table is used for both the document library and lists features. Lists with URL data types only store a reference to the URLs table.

The following table indicates the fields and data types that are used in the DocMd table.

Column Name Data Type Description
UrlID Counter Primary key for the table. Uniquely identifies each row.
Url Long Text The text of the URL. Each URL can only appear once in the table, and 450 is the maximum-length field that can be indexed. Internal URLs are stored as absolute.
Path Long Text The physical path to the file referred to in the URL.

See Also

Overview of the SharePoint Team Services Database

List Data Types

Using SQL with the SharePoint Team Services Database