Database Examples/Northwind/Categories
Fields
[edit | edit source]| Field Name | Field Type | Length | Index | Constraint | Default |
|---|---|---|---|---|---|
| CategoryID | Integer | Primary Key | Not Null | ||
| CategoryName | Text | 25 | Unique | Not Null | |
| Description | Text | 255 |
Data
[edit | edit source]| CategoryID | CategoryName | Description |
|---|---|---|
| 1 | Beverages | Soft drinks, coffees, teas, beers, and ales |
| 2 | Condiments | Sweet and savory sauces, relishes, spreads, and seasonings |
| 3 | Confections | Desserts, candies, and sweet breads |
| 4 | Dairy Products | Cheeses |
| 5 | Grains/Cereals | Breads, crackers, pasta, and cereal |
| 6 | Meat/Poultry | Prepared meats |
| 7 | Produce | Dried fruit and bean curd |
| 8 | Seafood | Seaweed and fish |