Relationship: FK_EmployeeTerritories_Territories on EmployeeTerritories

Collapse All Expand All

Relationship Properties

Name	Value
Not For Replication

FK Columns

	EmployeeTerritories Column	Territories Column	Type
	TerritoryID	TerritoryID	nvarchar

Extended Properties

SQL

ALTER TABLE [dbo].[EmployeeTerritories]
    ADD CONSTRAINT [FK_EmployeeTerritories_Territories]
    FOREIGN KEY ([TerritoryID]) REFERENCES [dbo].[Territories] ([TerritoryID])
GO

See also

Buildmasters.com.au