Northwind

Basic Index   Expanded Index

Table Name:EmployeeTerritories
Primary Keys:EmployeeID
TerritoryID
FieldTypeDefaultsNulls?
EmployeeIDintNoneNo
TerritoryIDnvarchar (20)NoneNo

IndexClustered?Unique?Fields
PK_EmployeeTerritoriesNoNoEmployeeID
TerritoryID

No check constraints
Internal Foreign Key ConstraintAffected FieldSource Table
FK_EmployeeTerritories_EmployeesEmployeeIDEmployees
FK_EmployeeTerritories_TerritoriesTerritoryIDTerritories

No primary keys as foreign key constraints
No triggers