Difference between revisions of "Database Objects AdventureWorks 2008-05"

From dbscript Online Help
Jump to: navigation, search
(New page: == automatically generated == ms new parser (20091126 221728 AdvWorks2008-05-oltp.instawdb.sql) === Tables === Address (Person) [[Person.AddressType_(table)|...)
(No difference)

Revision as of 22:43, 26 November 2009

automatically generated

ms new parser (20091126 221728 AdvWorks2008-05-oltp.instawdb.sql)

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 ()

Flag ()

Name ()

NameStyle ()

OrderNumber ()

Phone ()

XML Schema Collections

AdditionalContactInfoSchemaCollection (Person)

HRResumeSchemaCollection (HumanResources)

IndividualSurveySchemaCollection (Sales)

ManuInstructionsSchemaCollection (Production)

ProductDescriptionSchemaCollection (Production)

StoreSurveySchemaCollection (Sales)