Difference between revisions of "Database Objects AdventureWorks"
(New page: == wikibot == === Tables === Address (Person) AddressType (Person) AWBuildVersion (dbo) [[P...) |
(No difference)
|
Revision as of 14:28, 3 January 2009
wikibot
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)