Table of Contents

  • Database: Northwind
    • Tables
      • dbo.Categories
        • Indexes
          • PK_Categories
            • CategoryName
          • dbo.CustomerCustomerDemo
            • Indexes
              • PK_CustomerCustomerDemo
              • Relationships
                • FK_CustomerCustomerDemo
                  • FK_CustomerCustomerDemo_Customers
                • dbo.CustomerDemographics
                  • Indexes
                    • PK_CustomerDemographics
                  • dbo.Customers
                    • Indexes
                      • PK_Customers
                        • City
                          • CompanyName
                            • PostalCode
                              • Region
                            • dbo.Employees
                              • Indexes
                                • PK_Employees
                                  • LastName
                                    • PostalCode
                                    • Relationships
                                      • FK_Employees_Employees
                                    • dbo.EmployeeTerritories
                                      • Indexes
                                        • PK_EmployeeTerritories
                                          • _WA_Sys_TerritoryID_36B12243
                                          • Relationships
                                            • FK_EmployeeTerritories_Employees
                                              • FK_EmployeeTerritories_Territories
                                            • dbo.Order Details
                                              • Indexes
                                                • PK_Order_Details
                                                  • OrderID
                                                    • OrdersOrder_Details
                                                      • ProductID
                                                        • ProductsOrder_Details
                                                        • Relationships
                                                          • FK_Order_Details_Orders
                                                            • FK_Order_Details_Products
                                                          • dbo.Orders
                                                            • Indexes
                                                              • PK_Orders
                                                                • CustomerID
                                                                  • CustomersOrders
                                                                    • EmployeeID
                                                                      • EmployeesOrders
                                                                        • OrderDate
                                                                          • ShippedDate
                                                                            • ShippersOrders
                                                                              • ShipPostalCode
                                                                              • Relationships
                                                                                • FK_Orders_Customers
                                                                                  • FK_Orders_Employees
                                                                                    • FK_Orders_Shippers
                                                                                  • dbo.Products
                                                                                    • Indexes
                                                                                      • PK_Products
                                                                                        • CategoriesProducts
                                                                                          • CategoryID
                                                                                            • ProductName
                                                                                              • SupplierID
                                                                                                • SuppliersProducts
                                                                                                • Relationships
                                                                                                  • FK_Products_Categories
                                                                                                    • FK_Products_Suppliers
                                                                                                  • dbo.Region
                                                                                                    • Indexes
                                                                                                      • PK_Region
                                                                                                    • dbo.Shippers
                                                                                                      • Indexes
                                                                                                        • PK_Shippers
                                                                                                      • dbo.Suppliers
                                                                                                        • Indexes
                                                                                                          • PK_Suppliers
                                                                                                            • CompanyName
                                                                                                              • PostalCode
                                                                                                            • dbo.Territories
                                                                                                              • Indexes
                                                                                                                • PK_Territories
                                                                                                                  • _WA_Sys_RegionID_35BCFE0A
                                                                                                                  • Relationships
                                                                                                                    • FK_Territories_Region
                                                                                                                • Views
                                                                                                                  • dbo.Alphabetical list of products
                                                                                                                    • dbo.Category Sales for 1997
                                                                                                                      • dbo.Current Product List
                                                                                                                        • dbo.Customer and Suppliers by City
                                                                                                                          • dbo.Invoices
                                                                                                                            • dbo.Order Details Extended
                                                                                                                              • dbo.Order Subtotals
                                                                                                                                • dbo.Orders Qry
                                                                                                                                  • dbo.Product Sales for 1997
                                                                                                                                    • dbo.Products Above Average Price
                                                                                                                                      • dbo.Products by Category
                                                                                                                                        • dbo.Quarterly Orders
                                                                                                                                          • dbo.Sales by Category
                                                                                                                                            • dbo.Sales Totals by Amount
                                                                                                                                              • dbo.Summary of Sales by Quarter
                                                                                                                                                • dbo.Summary of Sales by Year
                                                                                                                                                • Stored Procedures
                                                                                                                                                  • dbo.CustOrderHist
                                                                                                                                                    • dbo.CustOrdersDetail
                                                                                                                                                      • dbo.CustOrdersOrders
                                                                                                                                                        • dbo.Employee Sales by Country
                                                                                                                                                          • dbo.Sales by Year
                                                                                                                                                            • dbo.SalesByCategory
                                                                                                                                                              • dbo.Ten Most Expensive Products
                                                                                                                                                              • Users
                                                                                                                                                                • dbo
                                                                                                                                                                  • guest
                                                                                                                                                                  • Roles
                                                                                                                                                                    • public
                                                                                                                                                                      • db_owner
                                                                                                                                                                    • Server Info
                                                                                                                                                                      • Logins
                                                                                                                                                                        • project
                                                                                                                                                                          • sa
                                                                                                                                                                            • BUILTIN\Administrators
                                                                                                                                                                          • About