DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
DEFAULT on column UnitPriceDiscount|((0.0))
FOREIGN KEY|ProductID
|REFERENCES AdventureWorks.Production.Product (ProductID)
FOREIGN KEY|SalesOrderID
|REFERENCES AdventureWorks.Sales.SalesOrderHeader (SalesOrderID)
FOREIGN KEY|SpecialOfferID, ProductID
|REFERENCES AdventureWorks.Sales.SpecialOfferProduct (SpecialOfferID, ProductID)
PRIMARY KEY (clustered)|SalesOrderID, LineNumber
No foreign keys reference this table, or you do not have permissions on referencing tables.|