Databases > Northwind > Tables > Categories

Northwind

Categories

Created: Modified:

Columns

  • CategoryID
    [int] IDENTITY (1,1) NOT NULL
  • CategoryName
    [nvarchar](15) NOT NULL
  • Description
    [ntext] NULL
  • Picture
    [image] NULL

Indexes

  • PK_Categories
    UNIQUE CLUSTERED
    CategoryID
  • CategoryName
    NONCLUSTERED
    CategoryName

Sample Data

CategoryID
CategoryName
Description
Picture
1
Beverages
Soft drinks, coffees, teas, beers, and ales
[image]
2
Condiments
Sweet and savory sauces, relishes, spreads, and seasonings
[image]
3
Confections
Desserts, candies, and sweet breads
[image]
4
Dairy Products
Cheeses
[image]
5
Grains/Cereals
Breads, crackers, pasta, and cereal
[image]
6
Meat/Poultry
Prepared meats
[image]
7
Produce
Dried fruit and bean curd
[image]
8
Seafood
Seaweed and fish
[image]