ProductPhoto Table (AdventureWorks)

Contains images of the product.

ProductPhoto Table Definition

The ProductPhoto table is contained in the Production schema.

Column Data type Nullability Description

ProductPhotoID

int

Not null

Primary key for ProductPhoto rows.

ThumbNailPhoto

varbinary(max)

Null

Small image of the product.

ThumbnailPhotoFileName

nvarchar(50)

Null

Small image file name.

LargePhoto

varbinary(max)

Null

Large image of the product.

LargePhotoFileName

nvarchar(50)

Null

Large image file name.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

Product Table (AdventureWorks)
ProductProductPhoto Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance