Database Objects AdventureWorks

wikibot

adventureworks (mie60)

Tables

Address (Person)
AddressType (Person)
AWBuildVersion (dbo)
BillOfMaterials (Production)
Contact (Person)
ContactCreditCard (Sales)
ContactType (Person)
CountryRegion (Person)
CountryRegionCurrency (Sales)
CreditCard (Sales)
Culture (Production)
Currency (Sales)
CurrencyRate (Sales)
Customer (Sales)
CustomerAddress (Sales)
DatabaseLog (dbo)
Department (HumanResources)
Document (Production)
Employee (HumanResources)
EmployeeAddress (HumanResources)
EmployeeDepartmentHistory (HumanResources)
EmployeePayHistory (HumanResources)
ErrorLog (dbo)
Illustration (Production)
Individual (Sales)
JobCandidate (HumanResources)
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)
ProductVendor (Purchasing)
PurchaseOrderDetail (Purchasing)
PurchaseOrderHeader (Purchasing)
SalesOrderDetail (Sales)
SalesOrderHeader (Sales)
SalesOrderHeaderSalesReason (Sales)
SalesPerson (Sales)
SalesPersonQuotaHistory (Sales)
SalesReason (Sales)
SalesTaxRate (Sales)
SalesTerritory (Sales)
SalesTerritoryHistory (Sales)
ScrapReason (Production)
Shift (HumanResources)
ShipMethod (Purchasing)
ShoppingCartItem (Sales)
SpecialOffer (Sales)
SpecialOfferProduct (Sales)
StateProvince (Person)
Store (Sales)
StoreContact (Sales)
TransactionHistory (Production)
TransactionHistoryArchive (Production)
UnitMeasure (Production)
Vendor (Purchasing)
VendorAddress (Purchasing)
VendorContact (Purchasing)
WorkOrder (Production)
WorkOrderRouting (Production)

Views

vAdditionalContactInfo (Person)
vEmployee (HumanResources)
vEmployeeDepartment (HumanResources)
vEmployeeDepartmentHistory (HumanResources)
vIndividualCustomer (Sales)
vIndividualDemographics (Sales)
vJobCandidate (HumanResources)
vJobCandidateEducation (HumanResources)
vJobCandidateEmployment (HumanResources)
vProductAndDescription (Production)
vProductModelCatalogDescription (Production)
vProductModelInstructions (Production)
vSalesPerson (Sales)
vSalesPersonSalesByFiscalYears (Sales)
vStateProvinceCountryRegion (Person)
vStoreWithDemographics (Sales)
vVendor (Purchasing)

Procedures

uspGetBillOfMaterials (dbo)
uspGetEmployeeManagers (dbo)
uspGetManagerEmployees (dbo)
uspGetWhereUsedProductID (dbo)
uspLogError (dbo)
uspPrintError (dbo)
uspUpdateEmployeeHireInfo (HumanResources)
uspUpdateEmployeeLogin (HumanResources)
uspUpdateEmployeePersonalInfo (HumanResources)

Functions

ufnGetAccountingEndDate (dbo)
ufnGetAccountingStartDate (dbo)
ufnGetDocumentStatusText (dbo)
ufnGetProductDealerPrice (dbo)
ufnGetProductListPrice (dbo)
ufnGetProductStandardCost (dbo)
ufnGetPurchaseOrderStatusText (dbo)
ufnGetSalesOrderStatusText (dbo)
ufnGetStock (dbo)
ufnLeadingZeros (dbo)
ufnGetContactInformation (dbo)

Schemas

HumanResources
Person
Production
Purchasing
Sales

Types

AccountNumber (dbo)
Flag (dbo)
Name (dbo)
NameStyle (dbo)
OrderNumber (dbo)
Phone (dbo)

XML Schema Collections

AdditionalContactInfoSchemaCollection (Person)
HRResumeSchemaCollection (HumanResources)
IndividualSurveySchemaCollection (Sales)
ManuInstructionsSchemaCollection (Production)
ProductDescriptionSchemaCollection (Production)
StoreSurveySchemaCollection (Sales)

Database Triggers

ddlDatabaseTriggerLog