dbo.Products

Field Name	Type and Size	Default	Nullable
ProductID	int identity		NOT NULL
ProductName	nvarchar(40)		NOT NULL
SupplierID	int		NULL
CategoryID	int		NULL
QuantityPerUnit	nvarchar(20)		NULL
UnitPrice	money(19.4)	(0)	NULL
UnitsInStock	smallint	(0)	NULL
UnitsOnOrder	smallint	(0)	NULL
ReorderLevel	smallint	(0)	NULL
Discontinued	bit	(0)	NOT NULL

Primary key for table 'dbo.Products'

Primary Key Name	Fields
PK_Products	ProductID

Foreign keys for table 'dbo.Products', 2 items

Foreign	Primary
Products.CategoryID	Categories.CategoryID
Products.SupplierID	Suppliers.SupplierID

Indexes for table 'dbo.Products', 6 items

Index Name	Clustered	Unique	Fields
PK_Products	Yes	Yes	ProductID
CategoriesProducts	No	No	CategoryID
CategoryID	No	No	CategoryID
ProductName	No	No	ProductName
SupplierID	No	No	SupplierID
SuppliersProducts	No	No	SupplierID

Dependencies for table 'dbo.Products', 16 items

Object Name	Type
dbo.Alphabetical list of products	view
dbo.CK_Products_UnitPrice	check cns
dbo.CK_ReorderLevel	check cns
dbo.CK_UnitsInStock	check cns
dbo.CK_UnitsOnOrder	check cns
dbo.Current Product List	view
dbo.CustOrderHist	stored procedure
dbo.CustOrdersDetail	stored procedure
dbo.Invoices	view
dbo.Order Details Extended	view
dbo.Product Sales for 1997	view
dbo.Products Above Average Price	view
dbo.Products by Category	view
dbo.Sales by Category	view
dbo.SalesByCategory	stored procedure
dbo.Ten Most Expensive Products	stored procedure