AdventureWorks

Expanded Index     Schema XML

Group:  All Tables

Type:  Tables

dbo.AWBuildVersion

dbo.DatabaseLog

dbo.ErrorLog

HumanResources.Department

HumanResources.Employee

HumanResources.EmployeeAddress

HumanResources.EmployeeDepartmentHistory

HumanResources.EmployeePayHistory

HumanResources.JobCandidate

HumanResources.Shift

Person.Address

Person.AddressType

Person.Contact

Person.ContactType

Person.CountryRegion

Person.StateProvince

Production.BillOfMaterials

Production.Culture

Production.Document

Production.Illustration

Production.Location

Production.Product

Production.ProductCategory

Production.ProductCostHistory

Production.ProductDescription

Production.ProductDocument

Production.ProductInventory

Production.ProductListPriceHistory

Production.ProductModel

Production.ProductModelIllustration

Production.ProductModelProductDescriptionCulture

Production.ProductPhoto

Production.ProductProductPhoto

Production.ProductReview

Production.ProductSubcategory

Production.ScrapReason

Production.TransactionHistory

Production.TransactionHistoryArchive

Production.UnitMeasure

Production.WorkOrder

Production.WorkOrderRouting

Purchasing.ProductVendor

Purchasing.PurchaseOrderDetail

Purchasing.PurchaseOrderHeader

Purchasing.ShipMethod

Purchasing.Vendor

Purchasing.VendorAddress

Purchasing.VendorContact

Sales.ContactCreditCard

Sales.CountryRegionCurrency

Sales.CreditCard

Sales.Currency

Sales.CurrencyRate

Sales.Customer

Sales.CustomerAddress

Sales.Individual

Sales.SalesOrderDetail

Sales.SalesOrderHeader

Sales.SalesOrderHeaderSalesReason

Sales.SalesPerson

Sales.SalesPersonQuotaHistory

Sales.SalesReason

Sales.SalesTaxRate

Sales.SalesTerritory

Sales.SalesTerritoryHistory

Sales.ShoppingCartItem

Sales.SpecialOffer

Sales.SpecialOfferProduct

Sales.Store

Sales.StoreContact


Group:  All Views

Type:  Views

Person.vAdditionalContactInfo

HumanResources.vEmployee

HumanResources.vEmployeeDepartment

HumanResources.vEmployeeDepartmentHistory

Sales.vIndividualCustomer

Sales.vIndividualDemographics

HumanResources.vJobCandidate

HumanResources.vJobCandidateEducation

HumanResources.vJobCandidateEmployment

Production.vProductAndDescription

Production.vProductModelCatalogDescription

Production.vProductModelInstructions

Sales.vSalesPerson

Sales.vSalesPersonSalesByFiscalYears

Person.vStateProvinceCountryRegion

Sales.vStoreWithDemographics

Purchasing.vVendor


Group:  All Stored Procedures

Type:  Stored Procedures

dbo.uspGetBillOfMaterials

dbo.uspGetEmployeeManagers

dbo.uspGetManagerEmployees

dbo.uspGetWhereUsedProductID

dbo.uspLogError

dbo.uspPrintError

HumanResources.uspUpdateEmployeeHireInfo

HumanResources.uspUpdateEmployeeLogin

HumanResources.uspUpdateEmployeePersonalInfo


Group:  All Functions

Type:  Functions

dbo.ufnGetAccountingEndDate

dbo.ufnGetAccountingStartDate

dbo.ufnGetContactInformation

dbo.ufnGetDocumentStatusText

dbo.ufnGetProductDealerPrice

dbo.ufnGetProductListPrice

dbo.ufnGetProductStandardCost

dbo.ufnGetPurchaseOrderStatusText

dbo.ufnGetSalesOrderStatusText

dbo.ufnGetStock

dbo.ufnLeadingZeros