Database Examples/Northwind/Categories

Fields edit

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

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