DEFAULT on column ModifiedDate|(getdate())
FOREIGN KEY|ContactID
|REFERENCES AdventureWorks.Person.Contact (ContactID)
FOREIGN KEY|ContactTypeID
|REFERENCES AdventureWorks.Person.ContactType (ContactTypeID)
FOREIGN KEY|VendorID
|REFERENCES AdventureWorks.Purchasing.Vendor (VendorID)
PRIMARY KEY (clustered)|VendorID, ContactID
No foreign keys reference this table, or you do not have permissions on referencing tables.|