Name |
Value |
Not For Replication |
|
EmployeeDepartmentHistory column |
Shift column |
Type |
ShiftID |
ShiftID |
tinyint |
Name |
Value |
MS_Description |
Foreign key constraint referencing Shift.ShiftID |
/ -->
ALTER TABLE [HumanResources].[EmployeeDepartmentHistory]
WITH CHECK
ADD CONSTRAINT [FK_EmployeeDepartmentHistory_Shift_ShiftID]
FOREIGN KEY ([ShiftID]) REFERENCES [HumanResources].[Shift] ([ShiftID])
ALTER TABLE [HumanResources].[EmployeeDepartmentHistory]
CHECK CONSTRAINT [FK_EmployeeDepartmentHistory_Shift_ShiftID]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing Shift.ShiftID', 'SCHEMA', N'HumanResources', 'TABLE', N'EmployeeDepartmentHistory', 'CONSTRAINT', N'FK_EmployeeDepartmentHistory_Shift_ShiftID'
GO
|