Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Database Objects AdventureWorks

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/02/11 09:03


wikibot

adventureworks (mie60)

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

ddlDatabaseTriggerLog

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.