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