Properties

Primary Table Owner:	Sales
Primary Table:	SalesTerritory
Primary Key or Unique Constraint:	PK_SalesTerritory_TerritoryID
Delete Cascade:
Update Cascade:
Description:	Foreign key constraint referencing SalesTerritory.TerritoryID.

Relationship Columns

	Column	Reference Column	Type
	TerritoryID	TerritoryID	int

Total: 1 trigger(s)

SQL

ALTER TABLE [Sales].[SalesPerson] ADD CONSTRAINT [FK_SalesPerson_SalesTerritory_TerritoryID] FOREIGN KEY
    (
        [TerritoryID]
    ) REFERENCES [SalesTerritory] (
        [TerritoryID]
    )
GO

See Also

Table [Sales.SalesTerritory]
Table [Sales.SalesPerson]