Database reference - Northwind

Northwind -  indexes

Index overview

nametabledescription
Categories.CategoryNameCategoriesunique index on Categories
Categories.PrimaryKeyCategoriesprimary key index on Categories
Customers.PostalCodeCustomersindex on Customers
Customers.CityCustomersindex on Customers
Customers.PrimaryKeyCustomersprimary key index on Customers
Customers.CompanyNameCustomersindex on Customers
Customers.RegionCustomersindex on Customers
Employees.PostalCodeEmployeesindex on Employees
Employees.LastNameEmployeesindex on Employees
Employees.PrimaryKeyEmployeesprimary key index on Employees
Order Details.PrimaryKeyOrder Detailsprimary key index on Order Details
Order Details.ProductsOrder_DetailsOrder Detailsforeign key index on Order Details
Order Details.OrderIDOrder Detailsindex on Order Details
Order Details.OrdersOrder_DetailsOrder Detailsforeign key index on Order Details
Order Details.ProductIDOrder Detailsindex on Order Details
Orders.EmployeesOrdersOrdersforeign key index on Orders
Orders.CustomersOrdersOrdersforeign key index on Orders
Orders.ShipPostalCodeOrdersindex on Orders
Orders.ShippersOrdersOrdersforeign key index on Orders
Orders.EmployeeIDOrdersindex on Orders
Orders.ShippedDateOrdersindex on Orders
Orders.CustomerIDOrdersindex on Orders
Orders.OrderDateOrdersindex on Orders
Orders.PrimaryKeyOrdersprimary key index on Orders
Products.SupplierIDProductsindex on Products
Products.ProductNameProductsindex on Products
Products.PrimaryKeyProductsprimary key index on Products
Products.CategoryIDProductsindex on Products
Products.CategoriesProductsProductsforeign key index on Products
Products.SuppliersProductsProductsforeign key index on Products
Shippers.PrimaryKeyShippersprimary key index on Shippers
Suppliers.PostalCodeSuppliersindex on Suppliers
Suppliers.PrimaryKeySuppliersprimary key index on Suppliers
Suppliers.CompanyNameSuppliersindex on Suppliers



Documentation generated by SqlSpec