DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
FOREIGN KEY|ProductID
|REFERENCES AdventureWorks.Production.Product (ProductID)
FOREIGN KEY|SpecialOfferID
|REFERENCES AdventureWorks.Sales.SpecialOffer (SpecialOfferID)
PRIMARY KEY (clustered)|SpecialOfferID, ProductID