Northwind
| Table Name: | Shippers |
| Primary Keys: | ShipperID |
| Field | Type | Defaults | Nulls? |
|---|---|---|---|
| ShipperID | int | None | No |
| CompanyName | nvarchar (40) | None | No |
| Phone | nvarchar (24) | None | Yes |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Shippers | Yes | Yes | ShipperID |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_Orders_Shippers | Orders | ShipVia |