Table of Contents

• Summary
• Tables
1. dbo.AWBuildVersion
2. dbo.DatabaseLog
3. dbo.ErrorLog
4. HumanResources.Department
5. HumanResources.Employee
6. HumanResources.EmployeeAddress
7. HumanResources.EmployeeDepartmentHistory
8. HumanResources.EmployeePayHistory
9. HumanResources.JobCandidate
10. HumanResources.Shift
11. Person.Address
12. Person.AddressType
13. Person.Contact
14. Person.ContactType
15. Person.CountryRegion
16. Person.StateProvince
17. Production.BillOfMaterials
18. Production.Culture
19. Production.Document
20. Production.Illustration
21. Production.Location
22. Production.Product
23. Production.ProductCategory
24. Production.ProductCostHistory
25. Production.ProductDescription
26. Production.ProductDocument
27. Production.ProductInventory
28. Production.ProductListPriceHistory
29. Production.ProductModel
30. Production.ProductModelIllustration
31. Production.ProductModelProductDescriptionCulture
32. Production.ProductPhoto
33. Production.ProductProductPhoto
34. Production.ProductReview
35. Production.ProductSubcategory
36. Production.ScrapReason
37. Production.TransactionHistory
38. Production.TransactionHistoryArchive
39. Production.UnitMeasure
40. Production.WorkOrder
41. Production.WorkOrderRouting
42. Purchasing.ProductVendor
43. Purchasing.PurchaseOrderDetail
44. Purchasing.PurchaseOrderHeader
45. Purchasing.ShipMethod
46. Purchasing.Vendor
47. Purchasing.VendorAddress
48. Purchasing.VendorContact
49. Sales.ContactCreditCard
50. Sales.CountryRegionCurrency
51. Sales.CreditCard
52. Sales.Currency
53. Sales.CurrencyRate
54. Sales.Customer
55. Sales.CustomerAddress
56. Sales.Individual
57. Sales.SalesOrderDetail
58. Sales.SalesOrderHeader
59. Sales.SalesOrderHeaderSalesReason
60. Sales.SalesPerson
61. Sales.SalesPersonQuotaHistory
62. Sales.SalesReason
63. Sales.SalesTaxRate
64. Sales.SalesTerritory
65. Sales.SalesTerritoryHistory
66. Sales.ShoppingCartItem
67. Sales.SpecialOffer
68. Sales.SpecialOfferProduct
69. Sales.Store
70. Sales.StoreContact
• Views
1. HumanResources.vEmployee
2. HumanResources.vEmployeeDepartment
3. HumanResources.vEmployeeDepartmentHistory
4. HumanResources.vJobCandidate
5. HumanResources.vJobCandidateEducation
6. HumanResources.vJobCandidateEmployment
7. Person.vAdditionalContactInfo
8. Person.vStateProvinceCountryRegion
9. Production.vProductAndDescription
10. Production.vProductModelCatalogDescription
11. Production.vProductModelInstructions
12. Purchasing.vVendor
13. Sales.vIndividualCustomer
14. Sales.vIndividualDemographics
15. Sales.vSalesPerson
16. Sales.vSalesPersonSalesByFiscalYears
17. Sales.vStoreWithDemographics
• Procedures and Functions
1. dbo.ufnGetAccountingEndDate
2. dbo.ufnGetAccountingStartDate
3. dbo.ufnGetContactInformation
4. dbo.ufnGetDocumentStatusText
5. dbo.ufnGetProductDealerPrice
6. dbo.ufnGetProductListPrice
7. dbo.ufnGetProductStandardCost
8. dbo.ufnGetPurchaseOrderStatusText
9. dbo.ufnGetSalesOrderStatusText
10. dbo.ufnGetStock
11. dbo.ufnLeadingZeros
12. dbo.uspGetBillOfMaterials
13. dbo.uspGetEmployeeManagers
14. dbo.uspGetManagerEmployees
15. dbo.uspGetWhereUsedProductID
16. dbo.uspLogError
17. dbo.uspPrintError
18. HumanResources.uspUpdateEmployeeHireInfo
19. HumanResources.uspUpdateEmployeeLogin
20. HumanResources.uspUpdateEmployeePersonalInfo
• Rules
• Database Level Triggers
• Data Types