Share via


SpecialOfferProduct Table (AdventureWorks)

Is a cross-reference table that maps the products to the sales discounts.

SpecialOfferProduct Table Definition

The SpecialOfferProduct table is contained in the Sales schema.

Column Data type Nullability Description

SpecialOfferID

int

Not null

Primary key.

ProductID

int

Not Null

Product identification number. Foreign key to Product.ProductID.

rowguid

uniqueidentifier

Not null

ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

Product Table (AdventureWorks)
SpecialOffer Table (AdventureWorks)
SalesOrderDetail Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance