Properties

Primary Table Owner:	Person
Primary Table:	Contact
Primary Key or Unique Constraint:	PK_Contact_ContactID
Delete Cascade:
Update Cascade:
Description:	Foreign key constraint referencing Contact.ContactID.

Relationship Columns

	Column	Reference Column	Type
	ContactID	ContactID	int

Total: 1 trigger(s)

SQL

ALTER TABLE [Purchasing].[VendorContact] ADD CONSTRAINT [FK_VendorContact_Contact_ContactID] FOREIGN KEY
    (
        [ContactID]
    ) REFERENCES [Contact] (
        [ContactID]
    )
GO

See Also

Table [Person.Contact]
Table [Purchasing.VendorContact]