| [dbo].[AWBuildVersion].[PK_AWBuildVersion_SystemInformationID] | [dbo].[AWBuildVersion] | 8 | clustered, unique, primary key located on PRIMARY |
| [dbo].[DatabaseLog].[PK_DatabaseLog_DatabaseLogID] | [dbo].[DatabaseLog] | 16 | nonclustered, unique, primary key located on PRIMARY |
| [dbo].[ErrorLog].[PK_ErrorLog_ErrorLogID] | [dbo].[ErrorLog] | 0 | clustered, unique, primary key located on PRIMARY |
| PK__sysdiagrams__7D63964E | [dbo].[sysdiagrams] | | clustered, unique, primary key located on PRIMARY |
| UK_principal_name | [dbo].[sysdiagrams] | | nonclustered, unique, unique key located on PRIMARY |
| [HumanResources].[Department].[AK_Department_Name] | [HumanResources].[Department] | 16 | nonclustered, unique located on PRIMARY |
| [HumanResources].[Department].[PK_Department_DepartmentID] | [HumanResources].[Department] | 8 | clustered, unique, primary key located on PRIMARY |
| [HumanResources].[Employee].[AK_Employee_LoginID] | [HumanResources].[Employee] | 40 | nonclustered, unique located on PRIMARY |
| [HumanResources].[Employee].[AK_Employee_NationalIDNumber] | [HumanResources].[Employee] | 32 | nonclustered, unique located on PRIMARY |
| [HumanResources].[Employee].[AK_Employee_rowguid] | [HumanResources].[Employee] | 16 | nonclustered, unique located on PRIMARY |
| [HumanResources].[Employee].[IX_Employee_ManagerID] | [HumanResources].[Employee] | 16 | nonclustered located on PRIMARY |
| [HumanResources].[Employee].[PK_Employee_EmployeeID] | [HumanResources].[Employee] | 16 | clustered, unique, primary key located on PRIMARY |
| [HumanResources].[EmployeeAddress].[AK_EmployeeAddress_rowguid] | [HumanResources].[EmployeeAddress] | 16 | nonclustered, unique located on PRIMARY |
| [HumanResources].[EmployeeAddress].[PK_EmployeeAddress_EmployeeID_AddressID] | [HumanResources].[EmployeeAddress] | 16 | clustered, unique, primary key located on PRIMARY |
| [HumanResources].[EmployeeDepartmentHistory].[IX_EmployeeDepartmentHistory_DepartmentID] | [HumanResources].[EmployeeDepartmentHistory] | 16 | nonclustered located on PRIMARY |
| [HumanResources].[EmployeeDepartmentHistory].[IX_EmployeeDepartmentHistory_ShiftID] | [HumanResources].[EmployeeDepartmentHistory] | 16 | nonclustered located on PRIMARY |
| [HumanResources].[EmployeeDepartmentHistory].[PK_EmployeeDepartmentHistory_EmployeeID_StartDate_DepartmentID] | [HumanResources].[EmployeeDepartmentHistory] | 16 | clustered, unique, primary key located on PRIMARY |
| [HumanResources].[EmployeePayHistory].[PK_EmployeePayHistory_EmployeeID_RateChangeDate] | [HumanResources].[EmployeePayHistory] | 16 | clustered, unique, primary key located on PRIMARY |
| [HumanResources].[JobCandidate].[IX_JobCandidate_EmployeeID] | [HumanResources].[JobCandidate] | 16 | nonclustered located on PRIMARY |
| [HumanResources].[JobCandidate].[PK_JobCandidate_JobCandidateID] | [HumanResources].[JobCandidate] | 16 | clustered, unique, primary key located on PRIMARY |
| [HumanResources].[Shift].[AK_Shift_Name] | [HumanResources].[Shift] | 16 | nonclustered, unique located on PRIMARY |
| [HumanResources].[Shift].[AK_Shift_StartTime_EndTime] | [HumanResources].[Shift] | 16 | nonclustered, unique located on PRIMARY |
| [HumanResources].[Shift].[PK_Shift_ShiftID] | [HumanResources].[Shift] | 8 | clustered, unique, primary key located on PRIMARY |
| [Person].[Address].[AK_Address_rowguid] | [Person].[Address] | 464 | nonclustered, unique located on PRIMARY |
| [Person].[Address].[IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode] | [Person].[Address] | 1728 | nonclustered, unique located on PRIMARY |
| [Person].[Address].[IX_Address_StateProvinceID] | [Person].[Address] | 232 | nonclustered located on PRIMARY |
| [Person].[Address].[PK_Address_AddressID] | [Person].[Address] | 16 | clustered, unique, primary key located on PRIMARY |
| [Person].[AddressType].[AK_AddressType_Name] | [Person].[AddressType] | 16 | nonclustered, unique located on PRIMARY |
| [Person].[AddressType].[AK_AddressType_rowguid] | [Person].[AddressType] | 16 | nonclustered, unique located on PRIMARY |
| [Person].[AddressType].[PK_AddressType_AddressTypeID] | [Person].[AddressType] | 8 | clustered, unique, primary key located on PRIMARY |
| [Person].[Contact].[AK_Contact_rowguid] | [Person].[Contact] | 472 | nonclustered, unique located on PRIMARY |
| [Person].[Contact].[IX_Contact_EmailAddress] | [Person].[Contact] | 1408 | nonclustered located on PRIMARY |
| [Person].[Contact].[PK_Contact_ContactID] | [Person].[Contact] | 80 | clustered, unique, primary key located on PRIMARY |
| [Person].[Contact].[PXML_Contact_AddContact] | [Person].[Contact] | 0 | |
| [Person].[ContactType].[AK_ContactType_Name] | [Person].[ContactType] | 16 | nonclustered, unique located on PRIMARY |
| [Person].[ContactType].[PK_ContactType_ContactTypeID] | [Person].[ContactType] | 8 | clustered, unique, primary key located on PRIMARY |
| [Person].[CountryRegion].[AK_CountryRegion_Name] | [Person].[CountryRegion] | 16 | nonclustered, unique located on PRIMARY |
| [Person].[CountryRegion].[PK_CountryRegion_CountryRegionCode] | [Person].[CountryRegion] | 16 | clustered, unique, primary key located on PRIMARY |
| [Person].[StateProvince].[AK_StateProvince_Name] | [Person].[StateProvince] | 16 | nonclustered, unique located on PRIMARY |
| [Person].[StateProvince].[AK_StateProvince_rowguid] | [Person].[StateProvince] | 16 | nonclustered, unique located on PRIMARY |
| [Person].[StateProvince].[AK_StateProvince_StateProvinceCode_CountryRegionCode] | [Person].[StateProvince] | 16 | nonclustered, unique located on PRIMARY |
| [Person].[StateProvince].[PK_StateProvince_StateProvinceID] | [Person].[StateProvince] | 16 | clustered, unique, primary key located on PRIMARY |
| [Production].[BillOfMaterials].[AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate] | [Production].[BillOfMaterials] | 16 | clustered, unique located on PRIMARY |
| [Production].[BillOfMaterials].[IX_BillOfMaterials_UnitMeasureCode] | [Production].[BillOfMaterials] | 96 | nonclustered located on PRIMARY |
| [Production].[BillOfMaterials].[PK_BillOfMaterials_BillOfMaterialsID] | [Production].[BillOfMaterials] | 88 | nonclustered, unique, primary key located on PRIMARY |
| [Production].[Culture].[AK_Culture_Name] | [Production].[Culture] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[Culture].[PK_Culture_CultureID] | [Production].[Culture] | 8 | clustered, unique, primary key located on PRIMARY |
| [Production].[Document].[AK_Document_FileName_Revision] | [Production].[Document] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[Document].[PK_Document_DocumentID] | [Production].[Document] | 8 | clustered, unique, primary key located on PRIMARY |
| [Production].[Illustration].[PK_Illustration_IllustrationID] | [Production].[Illustration] | 8 | clustered, unique, primary key located on PRIMARY |
| [Production].[Location].[AK_Location_Name] | [Production].[Location] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[Location].[PK_Location_LocationID] | [Production].[Location] | 8 | clustered, unique, primary key located on PRIMARY |
| [Production].[Product].[AK_Product_Name] | [Production].[Product] | 40 | nonclustered, unique located on PRIMARY |
| [Production].[Product].[AK_Product_ProductNumber] | [Production].[Product] | 32 | nonclustered, unique located on PRIMARY |
| [Production].[Product].[AK_Product_rowguid] | [Production].[Product] | 32 | nonclustered, unique located on PRIMARY |
| [Production].[Product].[PK_Product_ProductID] | [Production].[Product] | 16 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductCategory].[AK_ProductCategory_Name] | [Production].[ProductCategory] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[ProductCategory].[AK_ProductCategory_rowguid] | [Production].[ProductCategory] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[ProductCategory].[PK_ProductCategory_ProductCategoryID] | [Production].[ProductCategory] | 8 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductCostHistory].[PK_ProductCostHistory_ProductID_StartDate] | [Production].[ProductCostHistory] | 16 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductDescription].[AK_ProductDescription_rowguid] | [Production].[ProductDescription] | 40 | nonclustered, unique located on PRIMARY |
| [Production].[ProductDescription].[PK_ProductDescription_ProductDescriptionID] | [Production].[ProductDescription] | 16 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductDocument].[PK_ProductDocument_ProductID_DocumentID] | [Production].[ProductDocument] | 8 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductInventory].[PK_ProductInventory_ProductID_LocationID] | [Production].[ProductInventory] | 16 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductListPriceHistory].[PK_ProductListPriceHistory_ProductID_StartDate] | [Production].[ProductListPriceHistory] | 16 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductModel].[AK_ProductModel_Name] | [Production].[ProductModel] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[ProductModel].[AK_ProductModel_rowguid] | [Production].[ProductModel] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[ProductModel].[PK_ProductModel_ProductModelID] | [Production].[ProductModel] | 16 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductModel].[PXML_ProductModel_CatalogDescription] | [Production].[ProductModel] | 0 | |
| [Production].[ProductModel].[PXML_ProductModel_Instructions] | [Production].[ProductModel] | 0 | |
| [Production].[ProductModelIllustration].[PK_ProductModelIllustration_ProductModelID_IllustrationID] | [Production].[ProductModelIllustration] | 8 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductModelProductDescriptionCulture].[PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID] | [Production].[ProductModelProductDescriptionCulture] | 16 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductPhoto].[PK_ProductPhoto_ProductPhotoID] | [Production].[ProductPhoto] | 16 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductProductPhoto].[PK_ProductProductPhoto_ProductID_ProductPhotoID] | [Production].[ProductProductPhoto] | 32 | nonclustered, unique, primary key located on PRIMARY |
| [Production].[ProductReview].[IX_ProductReview_ProductID_Name] | [Production].[ProductReview] | 40 | nonclustered located on PRIMARY |
| [Production].[ProductReview].[PK_ProductReview_ProductReviewID] | [Production].[ProductReview] | 16 | clustered, unique, primary key located on PRIMARY |
| [Production].[ProductSubcategory].[AK_ProductSubcategory_Name] | [Production].[ProductSubcategory] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[ProductSubcategory].[AK_ProductSubcategory_rowguid] | [Production].[ProductSubcategory] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[ProductSubcategory].[PK_ProductSubcategory_ProductSubcategoryID] | [Production].[ProductSubcategory] | 8 | clustered, unique, primary key located on PRIMARY |
| [Production].[ScrapReason].[AK_ScrapReason_Name] | [Production].[ScrapReason] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[ScrapReason].[PK_ScrapReason_ScrapReasonID] | [Production].[ScrapReason] | 8 | clustered, unique, primary key located on PRIMARY |
| [Production].[TransactionHistory].[IX_TransactionHistory_ProductID] | [Production].[TransactionHistory] | 1336 | nonclustered located on PRIMARY |
| [Production].[TransactionHistory].[IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID] | [Production].[TransactionHistory] | 1776 | nonclustered located on PRIMARY |
| [Production].[TransactionHistory].[PK_TransactionHistory_TransactionID] | [Production].[TransactionHistory] | 80 | clustered, unique, primary key located on PRIMARY |
| [Production].[TransactionHistoryArchive].[IX_TransactionHistoryArchive_ProductID] | [Production].[TransactionHistoryArchive] | 1064 | nonclustered located on PRIMARY |
| [Production].[TransactionHistoryArchive].[IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID] | [Production].[TransactionHistoryArchive] | 1424 | nonclustered located on PRIMARY |
| [Production].[TransactionHistoryArchive].[PK_TransactionHistoryArchive_TransactionID] | [Production].[TransactionHistoryArchive] | 80 | clustered, unique, primary key located on PRIMARY |
| [Production].[UnitMeasure].[AK_UnitMeasure_Name] | [Production].[UnitMeasure] | 16 | nonclustered, unique located on PRIMARY |
| [Production].[UnitMeasure].[PK_UnitMeasure_UnitMeasureCode] | [Production].[UnitMeasure] | 8 | clustered, unique, primary key located on PRIMARY |
| [Production].[WorkOrder].[IX_WorkOrder_ProductID] | [Production].[WorkOrder] | 872 | nonclustered located on PRIMARY |
| [Production].[WorkOrder].[IX_WorkOrder_ScrapReasonID] | [Production].[WorkOrder] | 880 | nonclustered located on PRIMARY |
| [Production].[WorkOrder].[PK_WorkOrder_WorkOrderID] | [Production].[WorkOrder] | 80 | clustered, unique, primary key located on PRIMARY |
| [Production].[WorkOrderRouting].[IX_WorkOrderRouting_ProductID] | [Production].[WorkOrderRouting] | 960 | nonclustered located on PRIMARY |
| [Production].[WorkOrderRouting].[PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence] | [Production].[WorkOrderRouting] | 80 | clustered, unique, primary key located on PRIMARY |
| [Purchasing].[ProductVendor].[IX_ProductVendor_UnitMeasureCode] | [Purchasing].[ProductVendor] | 16 | nonclustered located on PRIMARY |
| [Purchasing].[ProductVendor].[IX_ProductVendor_VendorID] | [Purchasing].[ProductVendor] | 16 | nonclustered located on PRIMARY |
| [Purchasing].[ProductVendor].[PK_ProductVendor_ProductID_VendorID] | [Purchasing].[ProductVendor] | 16 | clustered, unique, primary key located on PRIMARY |
| [Purchasing].[PurchaseOrderDetail].[IX_PurchaseOrderDetail_ProductID] | [Purchasing].[PurchaseOrderDetail] | 152 | nonclustered located on PRIMARY |
| [Purchasing].[PurchaseOrderDetail].[PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID] | [Purchasing].[PurchaseOrderDetail] | 16 | clustered, unique, primary key located on PRIMARY |
| [Purchasing].[PurchaseOrderHeader].[IX_PurchaseOrderHeader_EmployeeID] | [Purchasing].[PurchaseOrderHeader] | 64 | nonclustered located on PRIMARY |
| [Purchasing].[PurchaseOrderHeader].[IX_PurchaseOrderHeader_VendorID] | [Purchasing].[PurchaseOrderHeader] | 64 | nonclustered located on PRIMARY |
| [Purchasing].[PurchaseOrderHeader].[PK_PurchaseOrderHeader_PurchaseOrderID] | [Purchasing].[PurchaseOrderHeader] | 16 | clustered, unique, primary key located on PRIMARY |
| [Purchasing].[ShipMethod].[AK_ShipMethod_Name] | [Purchasing].[ShipMethod] | 16 | nonclustered, unique located on PRIMARY |
| [Purchasing].[ShipMethod].[AK_ShipMethod_rowguid] | [Purchasing].[ShipMethod] | 16 | nonclustered, unique located on PRIMARY |
| [Purchasing].[ShipMethod].[PK_ShipMethod_ShipMethodID] | [Purchasing].[ShipMethod] | 8 | clustered, unique, primary key located on PRIMARY |
| [Purchasing].[Vendor].[AK_Vendor_AccountNumber] | [Purchasing].[Vendor] | 16 | nonclustered, unique located on PRIMARY |
| [Purchasing].[Vendor].[PK_Vendor_VendorID] | [Purchasing].[Vendor] | 16 | clustered, unique, primary key located on PRIMARY |
| [Purchasing].[VendorAddress].[IX_VendorAddress_AddressID] | [Purchasing].[VendorAddress] | 16 | nonclustered located on PRIMARY |
| [Purchasing].[VendorAddress].[PK_VendorAddress_VendorID_AddressID] | [Purchasing].[VendorAddress] | 8 | clustered, unique, primary key located on PRIMARY |
| [Purchasing].[VendorContact].[IX_VendorContact_ContactID] | [Purchasing].[VendorContact] | 16 | nonclustered located on PRIMARY |
| [Purchasing].[VendorContact].[IX_VendorContact_ContactTypeID] | [Purchasing].[VendorContact] | 16 | nonclustered located on PRIMARY |
| [Purchasing].[VendorContact].[PK_VendorContact_VendorID_ContactID] | [Purchasing].[VendorContact] | 8 | clustered, unique, primary key located on PRIMARY |
| [Sales].[ContactCreditCard].[PK_ContactCreditCard_ContactID_CreditCardID] | [Sales].[ContactCreditCard] | 16 | clustered, unique, primary key located on PRIMARY |
| [Sales].[CountryRegionCurrency].[IX_CountryRegionCurrency_CurrencyCode] | [Sales].[CountryRegionCurrency] | 16 | nonclustered located on PRIMARY |
| [Sales].[CountryRegionCurrency].[PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode] | [Sales].[CountryRegionCurrency] | 8 | clustered, unique, primary key located on PRIMARY |
| [Sales].[CreditCard].[AK_CreditCard_CardNumber] | [Sales].[CreditCard] | 760 | nonclustered, unique located on PRIMARY |
| [Sales].[CreditCard].[PK_CreditCard_CreditCardID] | [Sales].[CreditCard] | 16 | clustered, unique, primary key located on PRIMARY |
| [Sales].[Currency].[AK_Currency_Name] | [Sales].[Currency] | 16 | nonclustered, unique located on PRIMARY |
| [Sales].[Currency].[PK_Currency_CurrencyCode] | [Sales].[Currency] | 8 | clustered, unique, primary key located on PRIMARY |
| [Sales].[CurrencyRate].[AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode] | [Sales].[CurrencyRate] | 384 | nonclustered, unique located on PRIMARY |
| [Sales].[CurrencyRate].[PK_CurrencyRate_CurrencyRateID] | [Sales].[CurrencyRate] | 16 | clustered, unique, primary key located on PRIMARY |
| [Sales].[Customer].[AK_Customer_AccountNumber] | [Sales].[Customer] | 416 | nonclustered, unique located on PRIMARY |
| [Sales].[Customer].[AK_Customer_rowguid] | [Sales].[Customer] | 456 | nonclustered, unique located on PRIMARY |
| [Sales].[Customer].[IX_Customer_TerritoryID] | [Sales].[Customer] | 288 | nonclustered located on PRIMARY |
| [Sales].[Customer].[PK_Customer_CustomerID] | [Sales].[Customer] | 16 | clustered, unique, primary key located on PRIMARY |
| [Sales].[CustomerAddress].[AK_CustomerAddress_rowguid] | [Sales].[CustomerAddress] | 536 | nonclustered, unique located on PRIMARY |
| [Sales].[CustomerAddress].[PK_CustomerAddress_CustomerID_AddressID] | [Sales].[CustomerAddress] | 16 | clustered, unique, primary key located on PRIMARY |
| [Sales].[Individual].[PK_Individual_CustomerID] | [Sales].[Individual] | 144 | clustered, unique, primary key located on PRIMARY |
| [Sales].[Individual].[PXML_Individual_Demographics] | [Sales].[Individual] | 0 | |
| [Sales].[Individual].[XMLPATH_Individual_Demographics] | [Sales].[Individual] | 0 | |
| [Sales].[Individual].[XMLPROPERTY_Individual_Demographics] | [Sales].[Individual] | 0 | |
| [Sales].[Individual].[XMLVALUE_Individual_Demographics] | [Sales].[Individual] | 0 | |
| [Sales].[SalesOrderDetail].[AK_SalesOrderDetail_rowguid] | [Sales].[SalesOrderDetail] | 3336 | nonclustered, unique located on PRIMARY |
| [Sales].[SalesOrderDetail].[IX_SalesOrderDetail_ProductID] | [Sales].[SalesOrderDetail] | 1896 | nonclustered located on PRIMARY |
| [Sales].[SalesOrderDetail].[PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID] | [Sales].[SalesOrderDetail] | 80 | clustered, unique, primary key located on PRIMARY |
| [Sales].[SalesOrderHeader].[AK_SalesOrderHeader_rowguid] | [Sales].[SalesOrderHeader] | 736 | nonclustered, unique located on PRIMARY |
| [Sales].[SalesOrderHeader].[AK_SalesOrderHeader_SalesOrderNumber] | [Sales].[SalesOrderHeader] | 800 | nonclustered, unique located on PRIMARY |
| [Sales].[SalesOrderHeader].[IX_SalesOrderHeader_CustomerID] | [Sales].[SalesOrderHeader] | 360 | nonclustered located on PRIMARY |
| [Sales].[SalesOrderHeader].[IX_SalesOrderHeader_SalesPersonID] | [Sales].[SalesOrderHeader] | 456 | nonclustered located on PRIMARY |
| [Sales].[SalesOrderHeader].[PK_SalesOrderHeader_SalesOrderID] | [Sales].[SalesOrderHeader] | 32 | clustered, unique, primary key located on PRIMARY |
| [Sales].[SalesOrderHeaderSalesReason].[PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID] | [Sales].[SalesOrderHeaderSalesReason] | 16 | clustered, unique, primary key located on PRIMARY |
| [Sales].[SalesPerson].[AK_SalesPerson_rowguid] | [Sales].[SalesPerson] | 16 | nonclustered, unique located on PRIMARY |
| [Sales].[SalesPerson].[PK_SalesPerson_SalesPersonID] | [Sales].[SalesPerson] | 8 | clustered, unique, primary key located on PRIMARY |
| [Sales].[SalesPersonQuotaHistory].[AK_SalesPersonQuotaHistory_rowguid] | [Sales].[SalesPersonQuotaHistory] | 16 | nonclustered, unique located on PRIMARY |
| [Sales].[SalesPersonQuotaHistory].[PK_SalesPersonQuotaHistory_SalesPersonID_QuotaDate] | [Sales].[SalesPersonQuotaHistory] | 16 | clustered, unique, primary key located on PRIMARY |
| [Sales].[SalesReason].[PK_SalesReason_SalesReasonID] | [Sales].[SalesReason] | 8 | clustered, unique, primary key located on PRIMARY |
| [Sales].[SalesTaxRate].[AK_SalesTaxRate_rowguid] | [Sales].[SalesTaxRate] | 16 | nonclustered, unique located on PRIMARY |
| [Sales].[SalesTaxRate].[AK_SalesTaxRate_StateProvinceID_TaxType] | [Sales].[SalesTaxRate] | 16 | nonclustered, unique located on PRIMARY |
| [Sales].[SalesTaxRate].[PK_SalesTaxRate_SalesTaxRateID] | [Sales].[SalesTaxRate] | 8 | clustered, unique, primary key located on PRIMARY |
| [Sales].[SalesTerritory].[AK_SalesTerritory_Name] | [Sales].[SalesTerritory] | 16 | nonclustered, unique located on PRIMARY |
| [Sales].[SalesTerritory].[AK_SalesTerritory_rowguid] | [Sales].[SalesTerritory] | 16 | nonclustered, unique located on PRIMARY |
| [Sales].[SalesTerritory].[PK_SalesTerritory_TerritoryID] | [Sales].[SalesTerritory] | 8 | clustered, unique, primary key located on PRIMARY |
| [Sales].[SalesTerritoryHistory].[AK_SalesTerritoryHistory_rowguid] | [Sales].[SalesTerritoryHistory] | 16 | nonclustered, unique located on PRIMARY |
| [Sales].[SalesTerritoryHistory].[PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID] | [Sales].[SalesTerritoryHistory] | 8 | clustered, unique, primary key located on PRIMARY |
| [Sales].[ShoppingCartItem].[IX_ShoppingCartItem_ShoppingCartID_ProductID] | [Sales].[ShoppingCartItem] | 16 | nonclustered located on PRIMARY |
| [Sales].[ShoppingCartItem].[PK_ShoppingCartItem_ShoppingCartItemID] | [Sales].[ShoppingCartItem] | 8 | clustered, unique, primary key located on PRIMARY |
| [Sales].[SpecialOffer].[AK_SpecialOffer_rowguid] | [Sales].[SpecialOffer] | 16 | nonclustered, unique located on PRIMARY |
| [Sales].[SpecialOffer].[PK_SpecialOffer_SpecialOfferID] | [Sales].[SpecialOffer] | 8 | clustered, unique, primary key located on PRIMARY |
| [Sales].[SpecialOfferProduct].[AK_SpecialOfferProduct_rowguid] | [Sales].[SpecialOfferProduct] | 32 | nonclustered, unique located on PRIMARY |
| [Sales].[SpecialOfferProduct].[IX_SpecialOfferProduct_ProductID] | [Sales].[SpecialOfferProduct] | 16 | nonclustered located on PRIMARY |
| [Sales].[SpecialOfferProduct].[PK_SpecialOfferProduct_SpecialOfferID_ProductID] | [Sales].[SpecialOfferProduct] | 16 | clustered, unique, primary key located on PRIMARY |
| [Sales].[Store].[AK_Store_rowguid] | [Sales].[Store] | 32 | nonclustered, unique located on PRIMARY |
| [Sales].[Store].[IX_Store_SalesPersonID] | [Sales].[Store] | 32 | nonclustered located on PRIMARY |
| [Sales].[Store].[PK_Store_CustomerID] | [Sales].[Store] | 16 | clustered, unique, primary key located on PRIMARY |
| [Sales].[Store].[PXML_Store_Demographics] | [Sales].[Store] | 0 | |
| [Sales].[StoreContact].[AK_StoreContact_rowguid] | [Sales].[StoreContact] | 40 | nonclustered, unique located on PRIMARY |
| [Sales].[StoreContact].[IX_StoreContact_ContactID] | [Sales].[StoreContact] | 32 | nonclustered located on PRIMARY |
| [Sales].[StoreContact].[IX_StoreContact_ContactTypeID] | [Sales].[StoreContact] | 32 | nonclustered located on PRIMARY |
| [Sales].[StoreContact].[PK_StoreContact_CustomerID_ContactID] | [Sales].[StoreContact] | 16 | clustered, unique, primary key located on PRIMARY |