Properties

Primary Table Owner:	Production
Primary Table:	ScrapReason
Primary Key or Unique Constraint:	PK_ScrapReason_ScrapReasonID
Delete Cascade:
Update Cascade:
Description:	Foreign key constraint referencing ScrapReason.ScrapReasonID.

Relationship Columns

	Column	Reference Column	Type
	ScrapReasonID	ScrapReasonID	smallint

Total: 1 trigger(s)

SQL

ALTER TABLE [Production].[WorkOrder] ADD CONSTRAINT [FK_WorkOrder_ScrapReason_ScrapReasonID] FOREIGN KEY
    (
        [ScrapReasonID]
    ) REFERENCES [ScrapReason] (
        [ScrapReasonID]
    )
GO

See Also

Table [Production.ScrapReason]
Table [Production.WorkOrder]