Difference between revisions of "Database Objects AdventureWorks"

From dbscript Online Help
Jump to: navigation, search
(Removing all content from page)
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
== wikibot ==
 +
adventureworks (mie60)
  
 +
=== Tables ===
 +
 +
[[Person.Address_(table)|Address (Person)]]
 +
 +
[[Person.AddressType_(table)|AddressType (Person)]]
 +
 +
[[dbo.AWBuildVersion_(table)|AWBuildVersion (dbo)]]
 +
 +
[[Production.BillOfMaterials_(table)|BillOfMaterials (Production)]]
 +
 +
[[Person.Contact_(table)|Contact (Person)]]
 +
 +
[[Sales.ContactCreditCard_(table)|ContactCreditCard (Sales)]]
 +
 +
[[Person.ContactType_(table)|ContactType (Person)]]
 +
 +
[[Person.CountryRegion_(table)|CountryRegion (Person)]]
 +
 +
[[Sales.CountryRegionCurrency_(table)|CountryRegionCurrency (Sales)]]
 +
 +
[[Sales.CreditCard_(table)|CreditCard (Sales)]]
 +
 +
[[Production.Culture_(table)|Culture (Production)]]
 +
 +
[[Sales.Currency_(table)|Currency (Sales)]]
 +
 +
[[Sales.CurrencyRate_(table)|CurrencyRate (Sales)]]
 +
 +
[[Sales.Customer_(table)|Customer (Sales)]]
 +
 +
[[Sales.CustomerAddress_(table)|CustomerAddress (Sales)]]
 +
 +
[[dbo.DatabaseLog_(table)|DatabaseLog (dbo)]]
 +
 +
[[HumanResources.Department_(table)|Department (HumanResources)]]
 +
 +
[[Production.Document_(table)|Document (Production)]]
 +
 +
[[HumanResources.Employee_(table)|Employee (HumanResources)]]
 +
 +
[[HumanResources.EmployeeAddress_(table)|EmployeeAddress (HumanResources)]]
 +
 +
[[HumanResources.EmployeeDepartmentHistory_(table)|EmployeeDepartmentHistory (HumanResources)]]
 +
 +
[[HumanResources.EmployeePayHistory_(table)|EmployeePayHistory (HumanResources)]]
 +
 +
[[dbo.ErrorLog_(table)|ErrorLog (dbo)]]
 +
 +
[[Production.Illustration_(table)|Illustration (Production)]]
 +
 +
[[Sales.Individual_(table)|Individual (Sales)]]
 +
 +
[[HumanResources.JobCandidate_(table)|JobCandidate (HumanResources)]]
 +
 +
[[Production.Location_(table)|Location (Production)]]
 +
 +
[[Production.Product_(table)|Product (Production)]]
 +
 +
[[Production.ProductCategory_(table)|ProductCategory (Production)]]
 +
 +
[[Production.ProductCostHistory_(table)|ProductCostHistory (Production)]]
 +
 +
[[Production.ProductDescription_(table)|ProductDescription (Production)]]
 +
 +
[[Production.ProductDocument_(table)|ProductDocument (Production)]]
 +
 +
[[Production.ProductInventory_(table)|ProductInventory (Production)]]
 +
 +
[[Production.ProductListPriceHistory_(table)|ProductListPriceHistory (Production)]]
 +
 +
[[Production.ProductModel_(table)|ProductModel (Production)]]
 +
 +
[[Production.ProductModelIllustration_(table)|ProductModelIllustration (Production)]]
 +
 +
[[Production.ProductModelProductDescriptionCulture_(table)|ProductModelProductDescriptionCulture (Production)]]
 +
 +
[[Production.ProductPhoto_(table)|ProductPhoto (Production)]]
 +
 +
[[Production.ProductProductPhoto_(table)|ProductProductPhoto (Production)]]
 +
 +
[[Production.ProductReview_(table)|ProductReview (Production)]]
 +
 +
[[Production.ProductSubcategory_(table)|ProductSubcategory (Production)]]
 +
 +
[[Purchasing.ProductVendor_(table)|ProductVendor (Purchasing)]]
 +
 +
[[Purchasing.PurchaseOrderDetail_(table)|PurchaseOrderDetail (Purchasing)]]
 +
 +
[[Purchasing.PurchaseOrderHeader_(table)|PurchaseOrderHeader (Purchasing)]]
 +
 +
[[Sales.SalesOrderDetail_(table)|SalesOrderDetail (Sales)]]
 +
 +
[[Sales.SalesOrderHeader_(table)|SalesOrderHeader (Sales)]]
 +
 +
[[Sales.SalesOrderHeaderSalesReason_(table)|SalesOrderHeaderSalesReason (Sales)]]
 +
 +
[[Sales.SalesPerson_(table)|SalesPerson (Sales)]]
 +
 +
[[Sales.SalesPersonQuotaHistory_(table)|SalesPersonQuotaHistory (Sales)]]
 +
 +
[[Sales.SalesReason_(table)|SalesReason (Sales)]]
 +
 +
[[Sales.SalesTaxRate_(table)|SalesTaxRate (Sales)]]
 +
 +
[[Sales.SalesTerritory_(table)|SalesTerritory (Sales)]]
 +
 +
[[Sales.SalesTerritoryHistory_(table)|SalesTerritoryHistory (Sales)]]
 +
 +
[[Production.ScrapReason_(table)|ScrapReason (Production)]]
 +
 +
[[HumanResources.Shift_(table)|Shift (HumanResources)]]
 +
 +
[[Purchasing.ShipMethod_(table)|ShipMethod (Purchasing)]]
 +
 +
[[Sales.ShoppingCartItem_(table)|ShoppingCartItem (Sales)]]
 +
 +
[[Sales.SpecialOffer_(table)|SpecialOffer (Sales)]]
 +
 +
[[Sales.SpecialOfferProduct_(table)|SpecialOfferProduct (Sales)]]
 +
 +
[[Person.StateProvince_(table)|StateProvince (Person)]]
 +
 +
[[Sales.Store_(table)|Store (Sales)]]
 +
 +
[[Sales.StoreContact_(table)|StoreContact (Sales)]]
 +
 +
[[Production.TransactionHistory_(table)|TransactionHistory (Production)]]
 +
 +
[[Production.TransactionHistoryArchive_(table)|TransactionHistoryArchive (Production)]]
 +
 +
[[Production.UnitMeasure_(table)|UnitMeasure (Production)]]
 +
 +
[[Purchasing.Vendor_(table)|Vendor (Purchasing)]]
 +
 +
[[Purchasing.VendorAddress_(table)|VendorAddress (Purchasing)]]
 +
 +
[[Purchasing.VendorContact_(table)|VendorContact (Purchasing)]]
 +
 +
[[Production.WorkOrder_(table)|WorkOrder (Production)]]
 +
 +
[[Production.WorkOrderRouting_(table)|WorkOrderRouting (Production)]]
 +
 +
=== Views ===
 +
 +
[[Person.vAdditionalContactInfo_(view)|vAdditionalContactInfo (Person)]]
 +
 +
[[HumanResources.vEmployee_(view)|vEmployee (HumanResources)]]
 +
 +
[[HumanResources.vEmployeeDepartment_(view)|vEmployeeDepartment (HumanResources)]]
 +
 +
[[HumanResources.vEmployeeDepartmentHistory_(view)|vEmployeeDepartmentHistory (HumanResources)]]
 +
 +
[[Sales.vIndividualCustomer_(view)|vIndividualCustomer (Sales)]]
 +
 +
[[Sales.vIndividualDemographics_(view)|vIndividualDemographics (Sales)]]
 +
 +
[[HumanResources.vJobCandidate_(view)|vJobCandidate (HumanResources)]]
 +
 +
[[HumanResources.vJobCandidateEducation_(view)|vJobCandidateEducation (HumanResources)]]
 +
 +
[[HumanResources.vJobCandidateEmployment_(view)|vJobCandidateEmployment (HumanResources)]]
 +
 +
[[Production.vProductAndDescription_(view)|vProductAndDescription (Production)]]
 +
 +
[[Production.vProductModelCatalogDescription_(view)|vProductModelCatalogDescription (Production)]]
 +
 +
[[Production.vProductModelInstructions_(view)|vProductModelInstructions (Production)]]
 +
 +
[[Sales.vSalesPerson_(view)|vSalesPerson (Sales)]]
 +
 +
[[Sales.vSalesPersonSalesByFiscalYears_(view)|vSalesPersonSalesByFiscalYears (Sales)]]
 +
 +
[[Person.vStateProvinceCountryRegion_(view)|vStateProvinceCountryRegion (Person)]]
 +
 +
[[Sales.vStoreWithDemographics_(view)|vStoreWithDemographics (Sales)]]
 +
 +
[[Purchasing.vVendor_(view)|vVendor (Purchasing)]]
 +
 +
=== Procedures ===
 +
 +
[[dbo.uspGetBillOfMaterials_(procedure)|uspGetBillOfMaterials (dbo)]]
 +
 +
[[dbo.uspGetEmployeeManagers_(procedure)|uspGetEmployeeManagers (dbo)]]
 +
 +
[[dbo.uspGetManagerEmployees_(procedure)|uspGetManagerEmployees (dbo)]]
 +
 +
[[dbo.uspGetWhereUsedProductID_(procedure)|uspGetWhereUsedProductID (dbo)]]
 +
 +
[[dbo.uspLogError_(procedure)|uspLogError (dbo)]]
 +
 +
[[dbo.uspPrintError_(procedure)|uspPrintError (dbo)]]
 +
 +
[[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|uspUpdateEmployeeHireInfo (HumanResources)]]
 +
 +
[[HumanResources.uspUpdateEmployeeLogin_(procedure)|uspUpdateEmployeeLogin (HumanResources)]]
 +
 +
[[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|uspUpdateEmployeePersonalInfo (HumanResources)]]
 +
 +
=== Functions ===
 +
 +
[[dbo.ufnGetAccountingEndDate_(function)|ufnGetAccountingEndDate (dbo)]]
 +
 +
[[dbo.ufnGetAccountingStartDate_(function)|ufnGetAccountingStartDate (dbo)]]
 +
 +
[[dbo.ufnGetDocumentStatusText_(function)|ufnGetDocumentStatusText (dbo)]]
 +
 +
[[dbo.ufnGetProductDealerPrice_(function)|ufnGetProductDealerPrice (dbo)]]
 +
 +
[[dbo.ufnGetProductListPrice_(function)|ufnGetProductListPrice (dbo)]]
 +
 +
[[dbo.ufnGetProductStandardCost_(function)|ufnGetProductStandardCost (dbo)]]
 +
 +
[[dbo.ufnGetPurchaseOrderStatusText_(function)|ufnGetPurchaseOrderStatusText (dbo)]]
 +
 +
[[dbo.ufnGetSalesOrderStatusText_(function)|ufnGetSalesOrderStatusText (dbo)]]
 +
 +
[[dbo.ufnGetStock_(function)|ufnGetStock (dbo)]]
 +
 +
[[dbo.ufnLeadingZeros_(function)|ufnLeadingZeros (dbo)]]
 +
 +
[[dbo.ufnGetContactInformation_(function)|ufnGetContactInformation (dbo)]]
 +
 +
=== Schemas ===
 +
 +
[[HumanResources_(schema)|HumanResources]]
 +
 +
[[Person_(schema)|Person]]
 +
 +
[[Production_(schema)|Production]]
 +
 +
[[Purchasing_(schema)|Purchasing]]
 +
 +
[[Sales_(schema)|Sales]]
 +
 +
=== Types ===
 +
 +
[[dbo.AccountNumber_(type)|AccountNumber (dbo)]]
 +
 +
[[dbo.Flag_(type)|Flag (dbo)]]
 +
 +
[[dbo.Name_(type)|Name (dbo)]]
 +
 +
[[dbo.NameStyle_(type)|NameStyle (dbo)]]
 +
 +
[[dbo.OrderNumber_(type)|OrderNumber (dbo)]]
 +
 +
[[dbo.Phone_(type)|Phone (dbo)]]
 +
 +
=== XML Schema Collections ===
 +
 +
[[Person.AdditionalContactInfoSchemaCollection_(xml_schema_collection)|AdditionalContactInfoSchemaCollection (Person)]]
 +
 +
[[HumanResources.HRResumeSchemaCollection_(xml_schema_collection)|HRResumeSchemaCollection (HumanResources)]]
 +
 +
[[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|IndividualSurveySchemaCollection (Sales)]]
 +
 +
[[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|ManuInstructionsSchemaCollection (Production)]]
 +
 +
[[Production.ProductDescriptionSchemaCollection_(xml_schema_collection)|ProductDescriptionSchemaCollection (Production)]]
 +
 +
[[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|StoreSurveySchemaCollection (Sales)]]
 +
 +
=== Database Triggers ===
 +
 +
[[ddlDatabaseTriggerLog_(database_trigger)|ddlDatabaseTriggerLog]]

Latest revision as of 00:05, 3 February 2010

wikibot[edit]

adventureworks (mie60)

Tables[edit]

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[edit]

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[edit]

uspGetBillOfMaterials (dbo)

uspGetEmployeeManagers (dbo)

uspGetManagerEmployees (dbo)

uspGetWhereUsedProductID (dbo)

uspLogError (dbo)

uspPrintError (dbo)

uspUpdateEmployeeHireInfo (HumanResources)

uspUpdateEmployeeLogin (HumanResources)

uspUpdateEmployeePersonalInfo (HumanResources)

Functions[edit]

ufnGetAccountingEndDate (dbo)

ufnGetAccountingStartDate (dbo)

ufnGetDocumentStatusText (dbo)

ufnGetProductDealerPrice (dbo)

ufnGetProductListPrice (dbo)

ufnGetProductStandardCost (dbo)

ufnGetPurchaseOrderStatusText (dbo)

ufnGetSalesOrderStatusText (dbo)

ufnGetStock (dbo)

ufnLeadingZeros (dbo)

ufnGetContactInformation (dbo)

Schemas[edit]

HumanResources

Person

Production

Purchasing

Sales

Types[edit]

AccountNumber (dbo)

Flag (dbo)

Name (dbo)

NameStyle (dbo)

OrderNumber (dbo)

Phone (dbo)

XML Schema Collections[edit]

AdditionalContactInfoSchemaCollection (Person)

HRResumeSchemaCollection (HumanResources)

IndividualSurveySchemaCollection (Sales)

ManuInstructionsSchemaCollection (Production)

ProductDescriptionSchemaCollection (Production)

StoreSurveySchemaCollection (Sales)

Database Triggers[edit]

ddlDatabaseTriggerLog

Retrieved from "http://dbshelp.devio.at/index.php?title=Database_Objects_AdventureWorks&oldid=2083"