Database Objects AdventureWorks

From dbscript Online Help

Jump to: navigation, search

Contents

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

Personal tools
dbscript.help
dbscript.web