Relationship: FK_EmployeeTerritories_Employees on EmployeeTerritories

Collapse All Expand All

Relationship Properties

Name	Value
Not For Replication

FK Columns

	EmployeeTerritories Column	Employees Column	Type
	EmployeeID	EmployeeID	int

Extended Properties

SQL

ALTER TABLE [dbo].[EmployeeTerritories]
    ADD CONSTRAINT [FK_EmployeeTerritories_Employees]
    FOREIGN KEY ([EmployeeID]) REFERENCES [dbo].[Employees] ([EmployeeID])
GO

See also

Buildmasters.com.au