dbo.Categories

Field Name	Type and Size	Default	Nullable
CategoryID	int identity		NOT NULL
CategoryName	nvarchar(15)		NOT NULL
Description	ntext		NULL
Picture	image		NULL

Primary key for table 'dbo.Categories'

Primary Key Name	Fields
PK_Categories	CategoryID

Indexes for table 'dbo.Categories', 2 items

Index Name	Clustered	Unique	Fields
PK_Categories	Yes	Yes	CategoryID
CategoryName	No	No	CategoryName

Dependencies for table 'dbo.Categories', 5 items

Object Name	Type
dbo.Alphabetical list of products	view
dbo.Product Sales for 1997	view
dbo.Products by Category	view
dbo.Sales by Category	view
dbo.SalesByCategory	stored procedure