Database Objects AdventureWorks

From dbscript Online Help
Revision as of 22:57, 2 February 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

adventureworks (mie 091228.2156)

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

Database trigger to audit all of the DDL changes made to the AdventureWorks database.