DEFAULT on column ModifiedDate|(getdate()) FOREIGN KEY|ProductID |REFERENCES AdventureWorks.Production.Product (ProductID) FOREIGN KEY|UnitMeasureCode |REFERENCES AdventureWorks.Production.UnitMeasure (UnitMeasureCode) FOREIGN KEY|VendorID |REFERENCES AdventureWorks.Purchasing.Vendor (VendorID) PRIMARY KEY (clustered)|ProductID, VendorID No foreign keys reference this table, or you do not have permissions on referencing tables.|