Primary Table Owner: | HumanResources |
Primary Table: | Shift |
Primary Key or Unique Constraint: | PK_Shift_ShiftID |
Delete Cascade: | |
Update Cascade: | |
Description: | Foreign key constraint referencing Shift.ShiftID |
Column | Reference Column | Type | |
ShiftID | ShiftID | tinyint |
ALTER TABLE [HumanResources].[EmployeeDepartmentHistory] ADD CONSTRAINT [FK_EmployeeDepartmentHistory_Shift_ShiftID] FOREIGN KEY
(
[ShiftID]
) REFERENCES [Shift] (
[ShiftID]
)
GO
See Also
Table [HumanResources.Shift]