DEFAULT on column ModifiedDate|(getdate()) DEFAULT on column Primary|((0)) FOREIGN KEY|ProductID |REFERENCES AdventureWorks.Production.Product (ProductID) FOREIGN KEY|ProductPhotoID |REFERENCES AdventureWorks.Production.ProductPhoto (ProductPhotoID) PRIMARY KEY (non-clustered)|ProductID, ProductPhotoID No foreign keys reference this table, or you do not have permissions on referencing tables.|