Database reference - Nwind_new

Nwind_new -  indexes

Index overview

nametabledescription
CategoryNameCategoriesnon-clustered, unique index on Categories
PrimaryKeyCategoriesnon-clustered, unique primary key on Categories
CityCustomersnon-clustered, non-unique index on Customers
CompanyNameCustomersnon-clustered, non-unique index on Customers
PostalCodeCustomersnon-clustered, non-unique index on Customers
PrimaryKeyCustomersnon-clustered, unique primary key on Customers
RegionCustomersnon-clustered, non-unique index on Customers
ULCustomerNameDBA_ULCustomernon-clustered, unique primary key on DBA_ULCustomer
LastNameEmployeesnon-clustered, non-unique index on Employees
PostalCodeEmployeesnon-clustered, non-unique index on Employees
PrimaryKeyEmployeesnon-clustered, unique primary key on Employees
OrderIDOrder Detailsnon-clustered, non-unique index on Order Details
OrdersOrder DetailsOrder Detailsnon-clustered, non-unique index on Order Details
PrimaryKeyOrder Detailsnon-clustered, unique primary key on Order Details
ProductIDOrder Detailsnon-clustered, non-unique index on Order Details
ProductsOrder DetailsOrder Detailsnon-clustered, non-unique index on Order Details
CustomerIDOrdersnon-clustered, non-unique index on Orders
CustomersOrdersOrdersnon-clustered, non-unique index on Orders
EmployeeIDOrdersnon-clustered, non-unique index on Orders
EmployeesOrdersOrdersnon-clustered, non-unique index on Orders
OrderDateOrdersnon-clustered, non-unique index on Orders
PrimaryKeyOrdersnon-clustered, unique primary key on Orders
ShippedDateOrdersnon-clustered, non-unique index on Orders
ShippersOrdersOrdersnon-clustered, non-unique index on Orders
ShipPostalCodeOrdersnon-clustered, non-unique index on Orders
CategoriesProductsProductsnon-clustered, non-unique index on Products
CategoryIDProductsnon-clustered, non-unique index on Products
PrimaryKeyProductsnon-clustered, unique primary key on Products
ProductNameProductsnon-clustered, non-unique index on Products
SupplierIDProductsnon-clustered, non-unique index on Products
SuppliersProductsProductsnon-clustered, non-unique index on Products
PrimaryKeyShippersnon-clustered, unique primary key on Shippers
CompanyNameSuppliersnon-clustered, non-unique index on Suppliers
PostalCodeSuppliersnon-clustered, non-unique index on Suppliers
PrimaryKeySuppliersnon-clustered, unique primary key on Suppliers
{828C9929-F95D-4FD5-9B1B-CE6B42B13F06}tblPropertiesnon-clustered, non-unique index on tblProperties
lngagentIDtblPropertiesnon-clustered, non-unique index on tblProperties
lngAgentID1tblPropertiesnon-clustered, non-unique index on tblProperties
PrimaryKeytblPropertiesnon-clustered, unique primary key on tblProperties
strAddressPostalCodetblPropertiesnon-clustered, non-unique index on tblProperties
lngFeatureIDtblPropertyFeaturesnon-clustered, non-unique index on tblPropertyFeatures
PrimaryKeytblPropertyFeaturesnon-clustered, unique primary key on tblPropertyFeatures



Documentation generated by SqlSpec