Properties

Primary Table Owner:	HumanResources
Primary Table:	Department
Primary Key or Unique Constraint:	PK_Department_DepartmentID
Delete Cascade:
Update Cascade:
Description:	Foreign key constraint referencing Department.DepartmentID.

Relationship Columns

	Column	Reference Column	Type
	DepartmentID	DepartmentID	smallint

Total: 1 trigger(s)

SQL

ALTER TABLE [HumanResources].[EmployeeDepartmentHistory] ADD CONSTRAINT [FK_EmployeeDepartmentHistory_Department_DepartmentID] FOREIGN KEY
    (
        [DepartmentID]
    ) REFERENCES [Department] (
        [DepartmentID]
    )
GO

See Also

Table [HumanResources.Department]
Table [HumanResources.EmployeeDepartmentHistory]