Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Document Table (AdventureWorks)
Collapse the table of content
Expand the table of content

Document Table (AdventureWorks)

Contains product maintenance documents stored as Microsoft Office Word files.

The Document table is contained in the Production schema.

Column

Data type

Nullability

Description

DocumentID

int

Not null

Primary key for Document rows.

Title

nvarchar(50)

Not null

Title of the document.

FileName

nvarchar(400)

Not null

Directory path and file name of the document.

FileExtension

nvarchar(8)

Not null

File extension indicating the document type. For example, .doc or .txt.

Revision

nvarchar(5)

Not null

Revision number of the document.

ChangeNumber

int

Not null

Engineering change approval number.

Status

tinyint

Not null

1 = Pending approval

2 = Approved

3 = Obsolete

DocumentSummary

nvarchar(max)

Null

Document abstract.

Document

varbinary(max)

Null

Complete document file.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

Community Additions

ADD
Show:
© 2015 Microsoft