• About This Sample
  • AdventureWorks Database
    • Overview
    • Schemas
      • dbo Schema
        • Overview
        • Tables
          • dbo.AWBuildVersion Table
            • Indexes
              • PK_AWBuildVersion_SystemInformationID Index
          • dbo.DatabaseLog Table
            • Indexes
              • PK_DatabaseLog_DatabaseLogID Index
          • dbo.ErrorLog Table
            • Indexes
              • PK_ErrorLog_ErrorLogID Index
        • Stored Procedures
          • dbo.uspGetBillOfMaterials Stored Procedure
          • dbo.uspGetEmployeeManagers Stored Procedure
          • dbo.uspGetManagerEmployees Stored Procedure
          • dbo.uspGetWhereUsedProductID Stored Procedure
          • dbo.uspLogError Stored Procedure
          • dbo.uspPrintError Stored Procedure
          • dbo.uspSearchCandidateResumes Stored Procedure
        • User Defined Functions
          • dbo.ufnGetAccountingEndDate User Defined Function
          • dbo.ufnGetAccountingStartDate User Defined Function
          • dbo.ufnGetContactInformation User Defined Function
          • dbo.ufnGetDocumentStatusText User Defined Function
          • dbo.ufnGetProductDealerPrice User Defined Function
          • dbo.ufnGetProductListPrice User Defined Function
          • dbo.ufnGetProductStandardCost User Defined Function
          • dbo.ufnGetPurchaseOrderStatusText User Defined Function
          • dbo.ufnGetSalesOrderStatusText User Defined Function
          • dbo.ufnGetStock User Defined Function
          • dbo.ufnLeadingZeros User Defined Function
        • User Defined Data Types
          • dbo.AccountNumber User Defined Data Type
          • dbo.Flag User Defined Data Type
          • dbo.Name User Defined Data Type
          • dbo.NameStyle User Defined Data Type
          • dbo.OrderNumber User Defined Data Type
          • dbo.Phone User Defined Data Type
      • HumanResources Schema
        • Overview
        • Tables
          • HumanResources.Department Table
            • Indexes
              • AK_Department_Name Index
              • PK_Department_DepartmentID Index
            • Relationships
              • FK_EmployeeDepartmentHistory_Department_DepartmentID Relationship
          • HumanResources.Employee Table
            • Indexes
              • AK_Employee_LoginID Index
              • AK_Employee_NationalIDNumber Index
              • AK_Employee_rowguid Index
              • IX_Employee_OrganizationLevel_OrganizationNode Index
              • IX_Employee_OrganizationNode Index
              • PK_Employee_BusinessEntityID Index
            • Triggers
              • dEmployee Trigger
            • Relationships
              • FK_Document_Employee_Owner Relationship
              • FK_Employee_Person_BusinessEntityID Relationship
              • FK_EmployeeDepartmentHistory_Employee_BusinessEntityID Relationship
              • FK_EmployeePayHistory_Employee_BusinessEntityID Relationship
              • FK_JobCandidate_Employee_BusinessEntityID Relationship
              • FK_PurchaseOrderHeader_Employee_EmployeeID Relationship
              • FK_SalesPerson_Employee_BusinessEntityID Relationship
          • HumanResources.EmployeeDepartmentHistory Table
            • Indexes
              • IX_EmployeeDepartmentHistory_DepartmentID Index
              • IX_EmployeeDepartmentHistory_ShiftID Index
              • PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID Index
            • Relationships
              • FK_EmployeeDepartmentHistory_Department_DepartmentID Relationship
              • FK_EmployeeDepartmentHistory_Employee_BusinessEntityID Relationship
              • FK_EmployeeDepartmentHistory_Shift_ShiftID Relationship
          • HumanResources.EmployeePayHistory Table
            • Indexes
              • PK_EmployeePayHistory_BusinessEntityID_RateChangeDate Index
            • Relationships
              • FK_EmployeePayHistory_Employee_BusinessEntityID Relationship
          • HumanResources.JobCandidate Table
            • Indexes
              • IX_JobCandidate_BusinessEntityID Index
              • PK_JobCandidate_JobCandidateID Index
            • Relationships
              • FK_JobCandidate_Employee_BusinessEntityID Relationship
          • HumanResources.Shift Table
            • Indexes
              • AK_Shift_Name Index
              • AK_Shift_StartTime_EndTime Index
              • PK_Shift_ShiftID Index
            • Relationships
              • FK_EmployeeDepartmentHistory_Shift_ShiftID Relationship
        • Views
          • HumanResources.vEmployee View
          • HumanResources.vEmployeeDepartment View
          • HumanResources.vEmployeeDepartmentHistory View
          • HumanResources.vJobCandidate View
          • HumanResources.vJobCandidateEducation View
          • HumanResources.vJobCandidateEmployment View
        • Stored Procedures
          • HumanResources.uspUpdateEmployeeHireInfo Stored Procedure
          • HumanResources.uspUpdateEmployeeLogin Stored Procedure
          • HumanResources.uspUpdateEmployeePersonalInfo Stored Procedure
      • Person Schema
        • Overview
        • Tables
          • Person.Address Table
            • Indexes
              • AK_Address_rowguid Index
              • IX_Address_AddressLine1_AddressLine2_City_StateProvinceID_PostalCode Index
              • IX_Address_StateProvinceID Index
              • PK_Address_AddressID Index
            • Relationships
              • FK_Address_StateProvince_StateProvinceID Relationship
              • FK_BusinessEntityAddress_Address_AddressID Relationship
              • FK_SalesOrderHeader_Address_BillToAddressID Relationship
              • FK_SalesOrderHeader_Address_ShipToAddressID Relationship
          • Person.AddressType Table
            • Indexes
              • AK_AddressType_Name Index
              • AK_AddressType_rowguid Index
              • PK_AddressType_AddressTypeID Index
            • Relationships
              • FK_BusinessEntityAddress_AddressType_AddressTypeID Relationship
          • Person.BusinessEntity Table
            • Indexes
              • AK_BusinessEntity_rowguid Index
              • PK_BusinessEntity_BusinessEntityID Index
            • Relationships
              • FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID Relationship
              • FK_BusinessEntityContact_BusinessEntity_BusinessEntityID Relationship
              • FK_Person_BusinessEntity_BusinessEntityID Relationship
              • FK_Store_BusinessEntity_BusinessEntityID Relationship
              • FK_Vendor_BusinessEntity_BusinessEntityID Relationship
          • Person.BusinessEntityAddress Table
            • Indexes
              • AK_BusinessEntityAddress_rowguid Index
              • IX_BusinessEntityAddress_AddressID Index
              • IX_BusinessEntityAddress_AddressTypeID Index
              • PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID Index
            • Relationships
              • FK_BusinessEntityAddress_Address_AddressID Relationship
              • FK_BusinessEntityAddress_AddressType_AddressTypeID Relationship
              • FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID Relationship
          • Person.BusinessEntityContact Table
            • Indexes
              • AK_BusinessEntityContact_rowguid Index
              • IX_BusinessEntityContact_ContactTypeID Index
              • IX_BusinessEntityContact_PersonID Index
              • PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID Index
            • Relationships
              • FK_BusinessEntityContact_BusinessEntity_BusinessEntityID Relationship
              • FK_BusinessEntityContact_ContactType_ContactTypeID Relationship
              • FK_BusinessEntityContact_Person_PersonID Relationship
          • Person.ContactType Table
            • Indexes
              • AK_ContactType_Name Index
              • PK_ContactType_ContactTypeID Index
            • Relationships
              • FK_BusinessEntityContact_ContactType_ContactTypeID Relationship
          • Person.CountryRegion Table
            • Indexes
              • AK_CountryRegion_Name Index
              • PK_CountryRegion_CountryRegionCode Index
            • Relationships
              • FK_CountryRegionCurrency_CountryRegion_CountryRegionCode Relationship
              • FK_SalesTerritory_CountryRegion_CountryRegionCode Relationship
              • FK_StateProvince_CountryRegion_CountryRegionCode Relationship
          • Person.EmailAddress Table
            • Indexes
              • IX_EmailAddress_EmailAddress Index
              • PK_EmailAddress_BusinessEntityID_EmailAddressID Index
            • Relationships
              • FK_EmailAddress_Person_BusinessEntityID Relationship
          • Person.Password Table
            • Indexes
              • PK_Password_BusinessEntityID Index
            • Relationships
              • FK_Password_Person_BusinessEntityID Relationship
          • Person.Person Table
            • Indexes
              • AK_Person_rowguid Index
              • IX_Person_LastName_FirstName_MiddleName Index
              • PK_Person_BusinessEntityID Index
              • PXML_Person_AddContact Index
              • PXML_Person_Demographics Index
              • XMLPATH_Person_Demographics Index
              • XMLPROPERTY_Person_Demographics Index
              • XMLVALUE_Person_Demographics Index
            • Triggers
              • iuPerson Trigger
            • Relationships
              • FK_BusinessEntityContact_Person_PersonID Relationship
              • FK_Customer_Person_PersonID Relationship
              • FK_EmailAddress_Person_BusinessEntityID Relationship
              • FK_Employee_Person_BusinessEntityID Relationship
              • FK_Password_Person_BusinessEntityID Relationship
              • FK_Person_BusinessEntity_BusinessEntityID Relationship
              • FK_PersonCreditCard_Person_BusinessEntityID Relationship
              • FK_PersonPhone_Person_BusinessEntityID Relationship
          • Person.PersonPhone Table
            • Indexes
              • IX_PersonPhone_PhoneNumber Index
              • PK_PersonPhone_BusinessEntityID_PhoneNumber_PhoneNumberTypeID Index
            • Relationships
              • FK_PersonPhone_Person_BusinessEntityID Relationship
              • FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID Relationship
          • Person.PhoneNumberType Table
            • Indexes
              • PK_PhoneNumberType_PhoneNumberTypeID Index
            • Relationships
              • FK_PersonPhone_PhoneNumberType_PhoneNumberTypeID Relationship
          • Person.StateProvince Table
            • Indexes
              • AK_StateProvince_Name Index
              • AK_StateProvince_rowguid Index
              • AK_StateProvince_StateProvinceCode_CountryRegionCode Index
              • PK_StateProvince_StateProvinceID Index
            • Relationships
              • FK_Address_StateProvince_StateProvinceID Relationship
              • FK_SalesTaxRate_StateProvince_StateProvinceID Relationship
              • FK_StateProvince_CountryRegion_CountryRegionCode Relationship
              • FK_StateProvince_SalesTerritory_TerritoryID Relationship
        • Views
          • Person.vAdditionalContactInfo View
          • Person.vStateProvinceCountryRegion View
      • Production Schema
        • Overview
        • Tables
          • Production.BillOfMaterials Table
            • Indexes
              • AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate Index
              • IX_BillOfMaterials_UnitMeasureCode Index
              • PK_BillOfMaterials_BillOfMaterialsID Index
            • Relationships
              • FK_BillOfMaterials_Product_ComponentID Relationship
              • FK_BillOfMaterials_Product_ProductAssemblyID Relationship
              • FK_BillOfMaterials_UnitMeasure_UnitMeasureCode Relationship
          • Production.Culture Table
            • Indexes
              • AK_Culture_Name Index
              • PK_Culture_CultureID Index
            • Relationships
              • FK_ProductModelProductDescriptionCulture_Culture_CultureID Relationship
          • Production.Document Table
            • Indexes
              • AK_Document_DocumentLevel_DocumentNode Index
              • AK_Document_rowguid Index
              • IX_Document_FileName_Revision Index
              • PK_Document_DocumentNode Index
              • UQ__Document__F73921F7C5112C2E Index
            • Relationships
              • FK_Document_Employee_Owner Relationship
              • FK_ProductDocument_Document_DocumentNode Relationship
          • Production.Illustration Table
            • Indexes
              • PK_Illustration_IllustrationID Index
            • Relationships
              • FK_ProductModelIllustration_Illustration_IllustrationID Relationship
          • Production.Location Table
            • Indexes
              • AK_Location_Name Index
              • PK_Location_LocationID Index
            • Relationships
              • FK_ProductInventory_Location_LocationID Relationship
              • FK_WorkOrderRouting_Location_LocationID Relationship
          • Production.Product Table
            • Indexes
              • AK_Product_Name Index
              • AK_Product_ProductNumber Index
              • AK_Product_rowguid Index
              • PK_Product_ProductID Index
            • Relationships
              • FK_BillOfMaterials_Product_ComponentID Relationship
              • FK_BillOfMaterials_Product_ProductAssemblyID Relationship
              • FK_Product_ProductModel_ProductModelID Relationship
              • FK_Product_ProductSubcategory_ProductSubcategoryID Relationship
              • FK_Product_UnitMeasure_SizeUnitMeasureCode Relationship
              • FK_Product_UnitMeasure_WeightUnitMeasureCode Relationship
              • FK_ProductCostHistory_Product_ProductID Relationship
              • FK_ProductDocument_Product_ProductID Relationship
              • FK_ProductInventory_Product_ProductID Relationship
              • FK_ProductListPriceHistory_Product_ProductID Relationship
              • FK_ProductProductPhoto_Product_ProductID Relationship
              • FK_ProductReview_Product_ProductID Relationship
              • FK_ProductVendor_Product_ProductID Relationship
              • FK_PurchaseOrderDetail_Product_ProductID Relationship
              • FK_ShoppingCartItem_Product_ProductID Relationship
              • FK_SpecialOfferProduct_Product_ProductID Relationship
              • FK_TransactionHistory_Product_ProductID Relationship
              • FK_WorkOrder_Product_ProductID Relationship
          • Production.ProductCategory Table
            • Indexes
              • AK_ProductCategory_Name Index
              • AK_ProductCategory_rowguid Index
              • PK_ProductCategory_ProductCategoryID Index
            • Relationships
              • FK_ProductSubcategory_ProductCategory_ProductCategoryID Relationship
          • Production.ProductCostHistory Table
            • Indexes
              • PK_ProductCostHistory_ProductID_StartDate Index
            • Relationships
              • FK_ProductCostHistory_Product_ProductID Relationship
          • Production.ProductDescription Table
            • Indexes
              • AK_ProductDescription_rowguid Index
              • PK_ProductDescription_ProductDescriptionID Index
            • Relationships
              • FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID Relationship
          • Production.ProductDocument Table
            • Indexes
              • PK_ProductDocument_ProductID_DocumentNode Index
            • Relationships
              • FK_ProductDocument_Document_DocumentNode Relationship
              • FK_ProductDocument_Product_ProductID Relationship
          • Production.ProductInventory Table
            • Indexes
              • PK_ProductInventory_ProductID_LocationID Index
            • Relationships
              • FK_ProductInventory_Location_LocationID Relationship
              • FK_ProductInventory_Product_ProductID Relationship
          • Production.ProductListPriceHistory Table
            • Indexes
              • PK_ProductListPriceHistory_ProductID_StartDate Index
            • Relationships
              • FK_ProductListPriceHistory_Product_ProductID Relationship
          • Production.ProductModel Table
            • Indexes
              • AK_ProductModel_Name Index
              • AK_ProductModel_rowguid Index
              • PK_ProductModel_ProductModelID Index
              • PXML_ProductModel_CatalogDescription Index
              • PXML_ProductModel_Instructions Index
            • Relationships
              • FK_Product_ProductModel_ProductModelID Relationship
              • FK_ProductModelIllustration_ProductModel_ProductModelID Relationship
              • FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID Relationship
          • Production.ProductModelIllustration Table
            • Indexes
              • PK_ProductModelIllustration_ProductModelID_IllustrationID Index
            • Relationships
              • FK_ProductModelIllustration_Illustration_IllustrationID Relationship
              • FK_ProductModelIllustration_ProductModel_ProductModelID Relationship
          • Production.ProductModelProductDescriptionCulture Table
            • Indexes
              • PK_ProductModelProductDescriptionCulture_ProductModelID_ProductDescriptionID_CultureID Index
            • Relationships
              • FK_ProductModelProductDescriptionCulture_Culture_CultureID Relationship
              • FK_ProductModelProductDescriptionCulture_ProductDescription_ProductDescriptionID Relationship
              • FK_ProductModelProductDescriptionCulture_ProductModel_ProductModelID Relationship
          • Production.ProductPhoto Table
            • Indexes
              • PK_ProductPhoto_ProductPhotoID Index
            • Relationships
              • FK_ProductProductPhoto_ProductPhoto_ProductPhotoID Relationship
          • Production.ProductProductPhoto Table
            • Indexes
              • PK_ProductProductPhoto_ProductID_ProductPhotoID Index
            • Relationships
              • FK_ProductProductPhoto_Product_ProductID Relationship
              • FK_ProductProductPhoto_ProductPhoto_ProductPhotoID Relationship
          • Production.ProductReview Table
            • Indexes
              • IX_ProductReview_ProductID_Name Index
              • PK_ProductReview_ProductReviewID Index
            • Relationships
              • FK_ProductReview_Product_ProductID Relationship
          • Production.ProductSubcategory Table
            • Indexes
              • AK_ProductSubcategory_Name Index
              • AK_ProductSubcategory_rowguid Index
              • PK_ProductSubcategory_ProductSubcategoryID Index
            • Relationships
              • FK_Product_ProductSubcategory_ProductSubcategoryID Relationship
              • FK_ProductSubcategory_ProductCategory_ProductCategoryID Relationship
          • Production.ScrapReason Table
            • Indexes
              • AK_ScrapReason_Name Index
              • PK_ScrapReason_ScrapReasonID Index
            • Relationships
              • FK_WorkOrder_ScrapReason_ScrapReasonID Relationship
          • Production.TransactionHistory Table
            • Indexes
              • IX_TransactionHistory_ProductID Index
              • IX_TransactionHistory_ReferenceOrderID_ReferenceOrderLineID Index
              • PK_TransactionHistory_TransactionID Index
            • Relationships
              • FK_TransactionHistory_Product_ProductID Relationship
          • Production.TransactionHistoryArchive Table
            • Indexes
              • IX_TransactionHistoryArchive_ProductID Index
              • IX_TransactionHistoryArchive_ReferenceOrderID_ReferenceOrderLineID Index
              • PK_TransactionHistoryArchive_TransactionID Index
          • Production.UnitMeasure Table
            • Indexes
              • AK_UnitMeasure_Name Index
              • PK_UnitMeasure_UnitMeasureCode Index
            • Relationships
              • FK_BillOfMaterials_UnitMeasure_UnitMeasureCode Relationship
              • FK_Product_UnitMeasure_SizeUnitMeasureCode Relationship
              • FK_Product_UnitMeasure_WeightUnitMeasureCode Relationship
              • FK_ProductVendor_UnitMeasure_UnitMeasureCode Relationship
          • Production.WorkOrder Table
            • Indexes
              • IX_WorkOrder_ProductID Index
              • IX_WorkOrder_ScrapReasonID Index
              • PK_WorkOrder_WorkOrderID Index
            • Triggers
              • iWorkOrder Trigger
              • uWorkOrder Trigger
            • Relationships
              • FK_WorkOrder_Product_ProductID Relationship
              • FK_WorkOrder_ScrapReason_ScrapReasonID Relationship
              • FK_WorkOrderRouting_WorkOrder_WorkOrderID Relationship
          • Production.WorkOrderRouting Table
            • Indexes
              • IX_WorkOrderRouting_ProductID Index
              • PK_WorkOrderRouting_WorkOrderID_ProductID_OperationSequence Index
            • Relationships
              • FK_WorkOrderRouting_Location_LocationID Relationship
              • FK_WorkOrderRouting_WorkOrder_WorkOrderID Relationship
        • Views
          • Production.vProductAndDescription View
          • Production.vProductModelCatalogDescription View
          • Production.vProductModelInstructions View
      • Purchasing Schema
        • Overview
        • Tables
          • Purchasing.ProductVendor Table
            • Indexes
              • IX_ProductVendor_BusinessEntityID Index
              • IX_ProductVendor_UnitMeasureCode Index
              • PK_ProductVendor_ProductID_BusinessEntityID Index
            • Relationships
              • FK_ProductVendor_Product_ProductID Relationship
              • FK_ProductVendor_UnitMeasure_UnitMeasureCode Relationship
              • FK_ProductVendor_Vendor_BusinessEntityID Relationship
          • Purchasing.PurchaseOrderDetail Table
            • Indexes
              • IX_PurchaseOrderDetail_ProductID Index
              • PK_PurchaseOrderDetail_PurchaseOrderID_PurchaseOrderDetailID Index
            • Triggers
              • iPurchaseOrderDetail Trigger
              • uPurchaseOrderDetail Trigger
            • Relationships
              • FK_PurchaseOrderDetail_Product_ProductID Relationship
              • FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID Relationship
          • Purchasing.PurchaseOrderHeader Table
            • Indexes
              • IX_PurchaseOrderHeader_EmployeeID Index
              • IX_PurchaseOrderHeader_VendorID Index
              • PK_PurchaseOrderHeader_PurchaseOrderID Index
            • Triggers
              • uPurchaseOrderHeader Trigger
            • Relationships
              • FK_PurchaseOrderHeader_Employee_EmployeeID Relationship
              • FK_PurchaseOrderHeader_ShipMethod_ShipMethodID Relationship
              • FK_PurchaseOrderHeader_Vendor_VendorID Relationship
          • Purchasing.ShipMethod Table
            • Indexes
              • AK_ShipMethod_Name Index
              • AK_ShipMethod_rowguid Index
              • PK_ShipMethod_ShipMethodID Index
          • Purchasing.Vendor Table
            • Indexes
              • AK_Vendor_AccountNumber Index
              • PK_Vendor_BusinessEntityID Index
            • Triggers
              • dVendor Trigger
            • Relationships
              • FK_Vendor_BusinessEntity_BusinessEntityID Relationship
        • Views
          • Purchasing.vVendorWithAddresses View
          • Purchasing.vVendorWithContacts View
      • Sales Schema
        • Overview
        • Tables
          • Sales.CountryRegionCurrency Table
            • Indexes
              • IX_CountryRegionCurrency_CurrencyCode Index
              • PK_CountryRegionCurrency_CountryRegionCode_CurrencyCode Index
            • Relationships
              • FK_CountryRegionCurrency_CountryRegion_CountryRegionCode Relationship
              • FK_CountryRegionCurrency_Currency_CurrencyCode Relationship
          • Sales.CreditCard Table
            • Indexes
              • AK_CreditCard_CardNumber Index
              • PK_CreditCard_CreditCardID Index
          • Sales.Currency Table
            • Indexes
              • AK_Currency_Name Index
              • PK_Currency_CurrencyCode Index
          • Sales.CurrencyRate Table
            • Indexes
              • AK_CurrencyRate_CurrencyRateDate_FromCurrencyCode_ToCurrencyCode Index
              • PK_CurrencyRate_CurrencyRateID Index
            • Relationships
              • FK_CurrencyRate_Currency_FromCurrencyCode Relationship
              • FK_CurrencyRate_Currency_ToCurrencyCode Relationship
          • Sales.Customer Table
            • Indexes
              • AK_Customer_AccountNumber Index
              • AK_Customer_rowguid Index
              • IX_Customer_TerritoryID Index
              • PK_Customer_CustomerID Index
            • Relationships
              • FK_Customer_Person_PersonID Relationship
              • FK_Customer_SalesTerritory_TerritoryID Relationship
              • FK_Customer_Store_StoreID Relationship
          • Sales.PersonCreditCard Table
            • Indexes
              • PK_PersonCreditCard_BusinessEntityID_CreditCardID Index
            • Relationships
              • FK_PersonCreditCard_CreditCard_CreditCardID Relationship
              • FK_PersonCreditCard_Person_BusinessEntityID Relationship
          • Sales.SalesOrderDetail Table
            • Indexes
              • AK_SalesOrderDetail_rowguid Index
              • IX_SalesOrderDetail_ProductID Index
              • PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID Index
            • Triggers
              • iduSalesOrderDetail Trigger
            • Relationships
              • FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID Relationship
              • FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID Relationship
          • Sales.SalesOrderHeader Table
            • Indexes
              • AK_SalesOrderHeader_rowguid Index
              • AK_SalesOrderHeader_SalesOrderNumber Index
              • IX_SalesOrderHeader_CustomerID Index
              • IX_SalesOrderHeader_SalesPersonID Index
              • PK_SalesOrderHeader_SalesOrderID Index
            • Triggers
              • uSalesOrderHeader Trigger
            • Relationships
              • FK_SalesOrderHeader_Address_BillToAddressID Relationship
              • FK_SalesOrderHeader_Address_ShipToAddressID Relationship
              • FK_SalesOrderHeader_CreditCard_CreditCardID Relationship
              • FK_SalesOrderHeader_CurrencyRate_CurrencyRateID Relationship
              • FK_SalesOrderHeader_Customer_CustomerID Relationship
              • FK_SalesOrderHeader_SalesPerson_SalesPersonID Relationship
              • FK_SalesOrderHeader_SalesTerritory_TerritoryID Relationship
              • FK_SalesOrderHeader_ShipMethod_ShipMethodID Relationship
          • Sales.SalesOrderHeaderSalesReason Table
            • Indexes
              • PK_SalesOrderHeaderSalesReason_SalesOrderID_SalesReasonID Index
            • Relationships
              • FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID Relationship
              • FK_SalesOrderHeaderSalesReason_SalesReason_SalesReasonID Relationship
          • Sales.SalesPerson Table
            • Indexes
              • AK_SalesPerson_rowguid Index
              • PK_SalesPerson_BusinessEntityID Index
            • Relationships
              • FK_SalesPerson_Employee_BusinessEntityID Relationship
              • FK_SalesPerson_SalesTerritory_TerritoryID Relationship
          • Sales.SalesPersonQuotaHistory Table
            • Indexes
              • AK_SalesPersonQuotaHistory_rowguid Index
              • PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate Index
            • Relationships
              • FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID Relationship
          • Sales.SalesReason Table
            • Indexes
              • PK_SalesReason_SalesReasonID Index
          • Sales.SalesTaxRate Table
            • Indexes
              • AK_SalesTaxRate_rowguid Index
              • AK_SalesTaxRate_StateProvinceID_TaxType Index
              • PK_SalesTaxRate_SalesTaxRateID Index
            • Relationships
              • FK_SalesTaxRate_StateProvince_StateProvinceID Relationship
          • Sales.SalesTerritory Table
            • Indexes
              • AK_SalesTerritory_Name Index
              • AK_SalesTerritory_rowguid Index
              • PK_SalesTerritory_TerritoryID Index
            • Relationships
              • FK_SalesTerritory_CountryRegion_CountryRegionCode Relationship
          • Sales.SalesTerritoryHistory Table
            • Indexes
              • AK_SalesTerritoryHistory_rowguid Index
              • PK_SalesTerritoryHistory_BusinessEntityID_StartDate_TerritoryID Index
            • Relationships
              • FK_SalesTerritoryHistory_SalesPerson_BusinessEntityID Relationship
              • FK_SalesTerritoryHistory_SalesTerritory_TerritoryID Relationship
          • Sales.ShoppingCartItem Table
            • Indexes
              • IX_ShoppingCartItem_ShoppingCartID_ProductID Index
              • PK_ShoppingCartItem_ShoppingCartItemID Index
            • Relationships
              • FK_ShoppingCartItem_Product_ProductID Relationship
          • Sales.SpecialOffer Table
            • Indexes
              • AK_SpecialOffer_rowguid Index
              • PK_SpecialOffer_SpecialOfferID Index
          • Sales.SpecialOfferProduct Table
            • Indexes
              • AK_SpecialOfferProduct_rowguid Index
              • IX_SpecialOfferProduct_ProductID Index
              • PK_SpecialOfferProduct_SpecialOfferID_ProductID Index
            • Relationships
              • FK_SpecialOfferProduct_Product_ProductID Relationship
              • FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID Relationship
          • Sales.Store Table
            • Indexes
              • AK_Store_rowguid Index
              • IX_Store_SalesPersonID Index
              • PK_Store_BusinessEntityID Index
              • PXML_Store_Demographics Index
            • Relationships
              • FK_Store_BusinessEntity_BusinessEntityID Relationship
              • FK_Store_SalesPerson_SalesPersonID Relationship
        • Views
          • Sales.vIndividualCustomer View
          • Sales.vPersonDemographics View
          • Sales.vSalesPerson View
          • Sales.vSalesPersonSalesByFiscalYears View
          • Sales.vStoreWithAddresses View
          • Sales.vStoreWithContacts View
          • Sales.vStoreWithDemographics View
    • Users
      • dbo User
      • guest User
      • INFORMATION_SCHEMA User
      • sys User
    • Roles
      • db_accessadmin Role
      • db_backupoperator Role
      • db_datareader Role
      • db_datawriter Role
      • db_ddladmin Role
      • db_denydatareader Role
      • db_denydatawriter Role
      • db_owner Role
      • db_securityadmin Role
      • public Role
    • File Groups
      • PRIMARY File Group
    • Full Text Catalogs
      • AW2016FullTextCatalog Full Text Catalog