Docs Table

The Docs table stores metadata about documents.

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
Id uniqueidentifier GUID of the document.
SiteId uniqueidentifier GUID of the site to which the document belongs.
DirName nvarchar Directory in which the file is stored.
LeafName nvarchar Name of the file or folder.
WebId uniqueidentifier GUID of the subsite to which the document belongs. Found in the Webs table.
ListId uniqueidentifier GUID of the list with which the document is associated.
DoclibRowId int Row ID of the document. Documents stored in a document library are numbered in the order in which they are uploaded.
Type tinyint 1 for a folder; 0 for a file.
Size int Size of the document.
MetaInfoSize int Size of the metadata.
Version int Current version number of the document. Initial version is 1.
UIVersion int Document version number that is displayed to users.
Dirty bit Value that indicates whether a document needs to be reparsed. When true, it is used to clean up links inside the document after a document rename.
CacheParseId uniqueidentifier GUID value used for optimistic concurrency checking.
DocFlags tinyint Bit field used for various settings.
ThicketFlag bit Value that indicates whether the document has additional supporting files.
CharSet int Assumed Microsoft Windows character set of the document.
TimeCreated datetime Date and time the file was created.
TimeLastModified datetime Date and time the file was modified.
NextToLastTimeModified datetime Date and time the file was modified previous to TimeLastModified.
MetaInfoTimeLastModified datetime Date and time the metadata was updated.
TimeLastWritten datetime Date and time the document was written.
SetupPath nvarchar Path from which the file was originally installed.
CheckoutUserId int ID of the user in the UserInfo table who has the file checked out.
CheckoutDate datetime Date and time that the file was checked out.
CheckoutExpires datetime Date and time that the checkout expires. Does not get cleared when the checkout expires.
CheckoutSize int Size of the file when it was checked out.
VersionCreatedSinceSTCheckout bit Flag that prevents multiple document versions from being created on a single short-term checkout.
LTCheckoutUserId int ID of the user in the UserInfo table who has the file checked out.
VirusVendorID int ID of the antivirus vendor.
VirusStatus int Status of the virus scan.
VirusInfo nvarchar Information about a virus, if detected.
MetaInfo image Metadata in a binary field.
Content image Content of the file in a binary field.
CheckoutContent image Field that overwrites the Content field when the file is checked in.