Northwind
| Table Name: | Categories |
| Primary Keys: | CategoryID |
| Field | Type | Defaults | Nulls? |
|---|---|---|---|
| CategoryID | int | None | No |
| CategoryName | nvarchar (15) | None | No |
| Description | ntext | None | Yes |
| Picture | image | None | Yes |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Categories | Yes | Yes | CategoryID |
| CategoryName | No | No | CategoryName |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_Products_Categories | Products | CategoryID |