Database : Northwind
		Report created by EasyStruct 4.5 on 8/16/2004

Tables

Views

Stored Procedures

Indexes

Views

Customer and Suppliers by City Top create view "Customer and Suppliers by City" AS SELECT City, CompanyName, ContactName, 'Customers' AS Relationship FROM Customers UNION SELECT City, CompanyName, ContactName, 'Suppliers' FROM Suppliers --ORDER BY City, CompanyName Dependencies Top Table Name Column Name Customers CompanyName Customers ContactName Customers City Suppliers CompanyName Suppliers ContactName Suppliers City Tables Views Stored Procedures Indexes Alphabetical list of products Top create view "Alphabetical list of products" AS SELECT Products.*, Categories.CategoryName FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID WHERE (((Products.Discontinued)=0)) Dependencies Top Table Name Column Name Products ProductID Products ProductName Products SupplierID Products CategoryID Products QuantityPerUnit Products UnitPrice Products UnitsInStock Products UnitsOnOrder Products ReorderLevel Products Discontinued Categories CategoryID Categories CategoryName Tables Views Stored Procedures Indexes Current Product List Top create view "Current Product List" AS SELECT Product_List.ProductID, Product_List.ProductName FROM Products AS Product_List WHERE (((Product_List.Discontinued)=0)) --ORDER BY Product_List.ProductName Dependencies Top Table Name Column Name Products ProductID Products ProductName Products Discontinued Tables Views Stored Procedures Indexes Orders Qry Top create view "Orders Qry" AS SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry, Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID Dependencies Top Table Name Column Name Orders OrderID Orders CustomerID Orders EmployeeID Orders OrderDate Orders RequiredDate Orders ShippedDate Orders ShipVia Orders Freight Orders ShipName Orders ShipAddress Orders ShipCity Orders ShipRegion Orders ShipPostalCode Orders ShipCountry Customers CustomerID Customers CompanyName Customers Address Customers City Customers Region Customers PostalCode Customers Country Tables Views Stored Procedures Indexes Products Above Average Price Top create view "Products Above Average Price" AS SELECT Products.ProductName, Products.UnitPrice FROM Products WHERE Products.UnitPrice>(SELECT AVG(UnitPrice) From Products) --ORDER BY Products.UnitPrice DESC Dependencies Top Table Name Column Name Products ProductName Products UnitPrice Tables Views Stored Procedures Indexes