Properties

Primary Table Owner:	Production
Primary Table:	Location
Primary Key or Unique Constraint:	PK_Location_LocationID
Delete Cascade:
Update Cascade:
Description:	Foreign key constraint referencing Location.LocationID.

Relationship Columns

	Column	Reference Column	Type
	LocationID	LocationID	smallint

Total: 1 trigger(s)

SQL

ALTER TABLE [Production].[ProductInventory] ADD CONSTRAINT [FK_ProductInventory_Location_LocationID] FOREIGN KEY
    (
        [LocationID]
    ) REFERENCES [Location] (
        [LocationID]
    )
GO

See Also

Table [Production.Location]
Table [Production.ProductInventory]