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.