Database Objects AdventureWorks
Contents
wikibot
adventureworks (mie 091228.2156)
Tables
EmployeeAddress (HumanResources)
EmployeeDepartmentHistory (HumanResources)
EmployeePayHistory (HumanResources)
ProductCostHistory (Production)
ProductDescription (Production)
ProductListPriceHistory (Production)
ProductModelIllustration (Production)
ProductModelProductDescriptionCulture (Production)
ProductProductPhoto (Production)
ProductSubcategory (Production)
PurchaseOrderDetail (Purchasing)
PurchaseOrderHeader (Purchasing)
SalesOrderHeaderSalesReason (Sales)
SalesPersonQuotaHistory (Sales)
TransactionHistory (Production)
TransactionHistoryArchive (Production)
Views
vAdditionalContactInfo (Person)
vEmployeeDepartment (HumanResources)
vEmployeeDepartmentHistory (HumanResources)
vIndividualDemographics (Sales)
vJobCandidate (HumanResources)
vJobCandidateEducation (HumanResources)
vJobCandidateEmployment (HumanResources)
vProductAndDescription (Production)
vProductModelCatalogDescription (Production)
vProductModelInstructions (Production)
vSalesPersonSalesByFiscalYears (Sales)
vStateProvinceCountryRegion (Person)
vStoreWithDemographics (Sales)
Procedures
uspGetWhereUsedProductID (dbo)
uspUpdateEmployeeHireInfo (HumanResources)
uspUpdateEmployeeLogin (HumanResources)
uspUpdateEmployeePersonalInfo (HumanResources)
Functions
ufnGetAccountingStartDate (dbo)
ufnGetDocumentStatusText (dbo)
ufnGetProductDealerPrice (dbo)
ufnGetProductStandardCost (dbo)
ufnGetPurchaseOrderStatusText (dbo)
ufnGetSalesOrderStatusText (dbo)
ufnGetContactInformation (dbo)
Schemas
Types
XML Schema Collections
AdditionalContactInfoSchemaCollection (Person)
HRResumeSchemaCollection (HumanResources)
IndividualSurveySchemaCollection (Sales)
ManuInstructionsSchemaCollection (Production)
ProductDescriptionSchemaCollection (Production)
StoreSurveySchemaCollection (Sales)
Database Triggers
Database trigger to audit all of the DDL changes made to the AdventureWorks database.