Description
Categories of Northwind products.
View properties
| name | value |
|---|
| name | ~sq_fCategories |
| created | 8/16/2008 9:43:31 PM |
| modified | 8/16/2008 9:43:31 PM
|
Columns
| column | datatype | length | nulls | comment |
|---|
| CategoryID | long | 4 | yes
| Number automatically assigned to a new category.
|
| CategoryName | text | 15 | no
| Name of food category.
|
| Description | memo | 0 | yes
| |
| Picture | OLE object | 0 | yes
| A picture representing the food category.
|
Dependency graph
Objects that ~sq_fCategories depends on
Sample rows
| CategoryID | CategoryName | Description | Picture |
|---|
| 1
| Beverages
| Soft drinks, coffees, teas, beers, and ales
| System.Byte[]
|
| 2
| Condiments
| Sweet and savory sauces, relishes, spreads, and seasonings
| System.Byte[]
|
| 3
| Confections
| Desserts, candies, and sweet breads
| System.Byte[]
|
| 4
| Dairy Products
| Cheeses
| System.Byte[]
|
| 5
| Grains/Cereals
| Breads, crackers, pasta, and cereal
| System.Byte[]
|
| 6
| Meat/Poultry
| Prepared meats
| System.Byte[]
|
| 7
| Produce
| Dried fruit and bean curd
| System.Byte[]
|
| 8
| Seafood
| Seaweed and fish
| System.Byte[]
|
Code
SELECT DISTINCTROW
*
FROM Categories;