Properties

Primary Table Owner:	Production
Primary Table:	Product
Primary Key or Unique Constraint:	PK_Product_ProductID
Delete Cascade:
Update Cascade:
Description:	Foreign key constraint referencing Product.ProductID.

Relationship Columns

	Column	Reference Column	Type
	ProductID	ProductID	int

Total: 1 trigger(s)

SQL

ALTER TABLE [Production].[ProductInventory] ADD CONSTRAINT [FK_ProductInventory_Product_ProductID] FOREIGN KEY
    (
        [ProductID]
    ) REFERENCES [Product] (
        [ProductID]
    )
GO

See Also

Table [Production.Product]
Table [Production.ProductInventory]