Database Objects AdventureWorks

Modified on 2011/08/27 11:16 by wikibot Categorized as Uncategorized
== wikibot ==
adventureworks (mie60)

=== Tables ===

[Person Address (table)|Address (Person)] {br}
	
[Person AddressType (table)|AddressType (Person)] {br}
	
[dbo AWBuildVersion (table)|AWBuildVersion (dbo)] {br}
	
[Production BillOfMaterials (table)|BillOfMaterials (Production)] {br}
	
[Person Contact (table)|Contact (Person)] {br}
	
[Sales ContactCreditCard (table)|ContactCreditCard (Sales)] {br}
	
[Person ContactType (table)|ContactType (Person)] {br}
	
[Person CountryRegion (table)|CountryRegion (Person)] {br}
	
[Sales CountryRegionCurrency (table)|CountryRegionCurrency (Sales)] {br}
	
[Sales CreditCard (table)|CreditCard (Sales)] {br}
	
[Production Culture (table)|Culture (Production)] {br}
	
[Sales Currency (table)|Currency (Sales)] {br}
	
[Sales CurrencyRate (table)|CurrencyRate (Sales)] {br}
	
[Sales Customer (table)|Customer (Sales)] {br}
	
[Sales CustomerAddress (table)|CustomerAddress (Sales)] {br}
	
[dbo DatabaseLog (table)|DatabaseLog (dbo)] {br}
	
[HumanResources Department (table)|Department (HumanResources)] {br}
	
[Production Document (table)|Document (Production)] {br}
	
[HumanResources Employee (table)|Employee (HumanResources)] {br}
	
[HumanResources EmployeeAddress (table)|EmployeeAddress (HumanResources)] {br}
	
[HumanResources EmployeeDepartmentHistory (table)|EmployeeDepartmentHistory (HumanResources)] {br}
	
[HumanResources EmployeePayHistory (table)|EmployeePayHistory (HumanResources)] {br}
	
[dbo ErrorLog (table)|ErrorLog (dbo)] {br}
	
[Production Illustration (table)|Illustration (Production)] {br}
	
[Sales Individual (table)|Individual (Sales)] {br}
	
[HumanResources JobCandidate (table)|JobCandidate (HumanResources)] {br}
	
[Production Location (table)|Location (Production)] {br}
	
[Production Product (table)|Product (Production)] {br}
	
[Production ProductCategory (table)|ProductCategory (Production)] {br}
	
[Production ProductCostHistory (table)|ProductCostHistory (Production)] {br}
	
[Production ProductDescription (table)|ProductDescription (Production)] {br}
	
[Production ProductDocument (table)|ProductDocument (Production)] {br}
	
[Production ProductInventory (table)|ProductInventory (Production)] {br}
	
[Production ProductListPriceHistory (table)|ProductListPriceHistory (Production)] {br}
	
[Production ProductModel (table)|ProductModel (Production)] {br}
	
[Production ProductModelIllustration (table)|ProductModelIllustration (Production)] {br}
	
[Production ProductModelProductDescriptionCulture (table)|ProductModelProductDescriptionCulture (Production)] {br}
	
[Production ProductPhoto (table)|ProductPhoto (Production)] {br}
	
[Production ProductProductPhoto (table)|ProductProductPhoto (Production)] {br}
	
[Production ProductReview (table)|ProductReview (Production)] {br}
	
[Production ProductSubcategory (table)|ProductSubcategory (Production)] {br}
	
[Purchasing ProductVendor (table)|ProductVendor (Purchasing)] {br}
	
[Purchasing PurchaseOrderDetail (table)|PurchaseOrderDetail (Purchasing)] {br}
	
[Purchasing PurchaseOrderHeader (table)|PurchaseOrderHeader (Purchasing)] {br}
	
[Sales SalesOrderDetail (table)|SalesOrderDetail (Sales)] {br}
	
[Sales SalesOrderHeader (table)|SalesOrderHeader (Sales)] {br}
	
[Sales SalesOrderHeaderSalesReason (table)|SalesOrderHeaderSalesReason (Sales)] {br}
	
[Sales SalesPerson (table)|SalesPerson (Sales)] {br}
	
[Sales SalesPersonQuotaHistory (table)|SalesPersonQuotaHistory (Sales)] {br}
	
[Sales SalesReason (table)|SalesReason (Sales)] {br}
	
[Sales SalesTaxRate (table)|SalesTaxRate (Sales)] {br}
	
[Sales SalesTerritory (table)|SalesTerritory (Sales)] {br}
	
[Sales SalesTerritoryHistory (table)|SalesTerritoryHistory (Sales)] {br}
	
[Production ScrapReason (table)|ScrapReason (Production)] {br}
	
[HumanResources Shift (table)|Shift (HumanResources)] {br}
	
[Purchasing ShipMethod (table)|ShipMethod (Purchasing)] {br}
	
[Sales ShoppingCartItem (table)|ShoppingCartItem (Sales)] {br}
	
[Sales SpecialOffer (table)|SpecialOffer (Sales)] {br}
	
[Sales SpecialOfferProduct (table)|SpecialOfferProduct (Sales)] {br}
	
[Person StateProvince (table)|StateProvince (Person)] {br}
	
[Sales Store (table)|Store (Sales)] {br}
	
[Sales StoreContact (table)|StoreContact (Sales)] {br}
	
[Production TransactionHistory (table)|TransactionHistory (Production)] {br}
	
[Production TransactionHistoryArchive (table)|TransactionHistoryArchive (Production)] {br}
	
[Production UnitMeasure (table)|UnitMeasure (Production)] {br}
	
[Purchasing Vendor (table)|Vendor (Purchasing)] {br}
	
[Purchasing VendorAddress (table)|VendorAddress (Purchasing)] {br}
	
[Purchasing VendorContact (table)|VendorContact (Purchasing)] {br}
	
[Production WorkOrder (table)|WorkOrder (Production)] {br}
	
[Production WorkOrderRouting (table)|WorkOrderRouting (Production)] {br}
	
=== Views ===

[Person vAdditionalContactInfo (view)|vAdditionalContactInfo (Person)] {br}
	
[HumanResources vEmployee (view)|vEmployee (HumanResources)] {br}
	
[HumanResources vEmployeeDepartment (view)|vEmployeeDepartment (HumanResources)] {br}
	
[HumanResources vEmployeeDepartmentHistory (view)|vEmployeeDepartmentHistory (HumanResources)] {br}
	
[Sales vIndividualCustomer (view)|vIndividualCustomer (Sales)] {br}
	
[Sales vIndividualDemographics (view)|vIndividualDemographics (Sales)] {br}
	
[HumanResources vJobCandidate (view)|vJobCandidate (HumanResources)] {br}
	
[HumanResources vJobCandidateEducation (view)|vJobCandidateEducation (HumanResources)] {br}
	
[HumanResources vJobCandidateEmployment (view)|vJobCandidateEmployment (HumanResources)] {br}
	
[Production vProductAndDescription (view)|vProductAndDescription (Production)] {br}
	
[Production vProductModelCatalogDescription (view)|vProductModelCatalogDescription (Production)] {br}
	
[Production vProductModelInstructions (view)|vProductModelInstructions (Production)] {br}
	
[Sales vSalesPerson (view)|vSalesPerson (Sales)] {br}
	
[Sales vSalesPersonSalesByFiscalYears (view)|vSalesPersonSalesByFiscalYears (Sales)] {br}
	
[Person vStateProvinceCountryRegion (view)|vStateProvinceCountryRegion (Person)] {br}
	
[Sales vStoreWithDemographics (view)|vStoreWithDemographics (Sales)] {br}
	
[Purchasing vVendor (view)|vVendor (Purchasing)] {br}
	
=== Procedures ===

[dbo uspGetBillOfMaterials (procedure)|uspGetBillOfMaterials (dbo)] {br}
	
[dbo uspGetEmployeeManagers (procedure)|uspGetEmployeeManagers (dbo)] {br}
	
[dbo uspGetManagerEmployees (procedure)|uspGetManagerEmployees (dbo)] {br}
	
[dbo uspGetWhereUsedProductID (procedure)|uspGetWhereUsedProductID (dbo)] {br}
	
[dbo uspLogError (procedure)|uspLogError (dbo)] {br}
	
[dbo uspPrintError (procedure)|uspPrintError (dbo)] {br}
	
[HumanResources uspUpdateEmployeeHireInfo (procedure)|uspUpdateEmployeeHireInfo (HumanResources)] {br}
	
[HumanResources uspUpdateEmployeeLogin (procedure)|uspUpdateEmployeeLogin (HumanResources)] {br}
	
[HumanResources uspUpdateEmployeePersonalInfo (procedure)|uspUpdateEmployeePersonalInfo (HumanResources)] {br}
	
=== Functions ===

[dbo ufnGetAccountingEndDate (function)|ufnGetAccountingEndDate (dbo)] {br}
	
[dbo ufnGetAccountingStartDate (function)|ufnGetAccountingStartDate (dbo)] {br}
	
[dbo ufnGetDocumentStatusText (function)|ufnGetDocumentStatusText (dbo)] {br}
	
[dbo ufnGetProductDealerPrice (function)|ufnGetProductDealerPrice (dbo)] {br}
	
[dbo ufnGetProductListPrice (function)|ufnGetProductListPrice (dbo)] {br}
	
[dbo ufnGetProductStandardCost (function)|ufnGetProductStandardCost (dbo)] {br}
	
[dbo ufnGetPurchaseOrderStatusText (function)|ufnGetPurchaseOrderStatusText (dbo)] {br}
	
[dbo ufnGetSalesOrderStatusText (function)|ufnGetSalesOrderStatusText (dbo)] {br}
	
[dbo ufnGetStock (function)|ufnGetStock (dbo)] {br}
	
[dbo ufnLeadingZeros (function)|ufnLeadingZeros (dbo)] {br}
	
[dbo ufnGetContactInformation (function)|ufnGetContactInformation (dbo)] {br}
	
=== Schemas ===

[HumanResources (schema)|HumanResources] {br}
	
[Person (schema)|Person] {br}
	
[Production (schema)|Production] {br}
	
[Purchasing (schema)|Purchasing] {br}
	
[Sales (schema)|Sales] {br}
	
=== Types ===

[dbo AccountNumber (type)|AccountNumber (dbo)] {br}
	
[dbo Flag (type)|Flag (dbo)] {br}
	
[dbo Name (type)|Name (dbo)] {br}
	
[dbo NameStyle (type)|NameStyle (dbo)] {br}
	
[dbo OrderNumber (type)|OrderNumber (dbo)] {br}
	
[dbo Phone (type)|Phone (dbo)] {br}
	
=== XML Schema Collections ===

[Person AdditionalContactInfoSchemaCollection (xml schema collection)|AdditionalContactInfoSchemaCollection (Person)] {br}
	
[HumanResources HRResumeSchemaCollection (xml schema collection)|HRResumeSchemaCollection (HumanResources)] {br}
	
[Sales IndividualSurveySchemaCollection (xml schema collection)|IndividualSurveySchemaCollection (Sales)] {br}
	
[Production ManuInstructionsSchemaCollection (xml schema collection)|ManuInstructionsSchemaCollection (Production)] {br}
	
[Production ProductDescriptionSchemaCollection (xml schema collection)|ProductDescriptionSchemaCollection (Production)] {br}
	
[Sales StoreSurveySchemaCollection (xml schema collection)|StoreSurveySchemaCollection (Sales)] {br}
	
=== Database Triggers ===

[ddlDatabaseTriggerLog (database trigger)|ddlDatabaseTriggerLog] {br}
devio dbscript ScrewTurn Wiki

Navigation¶

Database Objects AdventureWorks
