dbo.Products

Table: 'dbo.Products', 10 fields

Field NameType and SizeDefaultNullable
ProductIDint identity NOT NULL
ProductNamenvarchar(40) NOT NULL
SupplierIDint NULL
CategoryIDint NULL
QuantityPerUnitnvarchar(20) NULL
UnitPricemoney(19.4)(0)NULL
UnitsInStocksmallint(0)NULL
UnitsOnOrdersmallint(0)NULL
ReorderLevelsmallint(0)NULL
Discontinuedbit(0)NOT NULL

Primary key for table 'dbo.Products'

Primary Key NameFields
PK_ProductsProductID

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

ForeignPrimary
Products.CategoryIDCategories.CategoryID
Products.SupplierIDSuppliers.SupplierID

Indexes for table 'dbo.Products', 6 items

Index NameClusteredUniqueFields
PK_ProductsYesYesProductID
CategoriesProductsNoNoCategoryID
CategoryIDNoNoCategoryID
ProductNameNoNoProductName
SupplierIDNoNoSupplierID
SuppliersProductsNoNoSupplierID

Dependencies for table 'dbo.Products', 16 items

Object NameType
dbo.Alphabetical list of productsview
dbo.CK_Products_UnitPricecheck cns
dbo.CK_ReorderLevelcheck cns
dbo.CK_UnitsInStockcheck cns
dbo.CK_UnitsOnOrdercheck cns
dbo.Current Product Listview
dbo.CustOrderHiststored procedure
dbo.CustOrdersDetailstored procedure
dbo.Invoicesview
dbo.Order Details Extendedview
dbo.Product Sales for 1997view
dbo.Products Above Average Priceview
dbo.Products by Categoryview
dbo.Sales by Categoryview
dbo.SalesByCategorystored procedure
dbo.Ten Most Expensive Productsstored procedure