Northwind
| Table Name: | Territories |
| Primary Keys: | TerritoryID |
| Field | Type | Defaults | Nulls? |
|---|---|---|---|
| TerritoryID | nvarchar (20) | None | No |
| TerritoryDescription | nchar (50) | None | No |
| RegionID | int | None | No |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Territories | No | No | TerritoryID |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_Territories_Region | RegionID | Region |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_EmployeeTerritories_Territories | EmployeeTerritories | TerritoryID |