ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
Database Objects AdventureWorks
Print
RSS
Modified: 2011/08/27 10:13 by
wikibot
-
Uncategorized
»
Database Objects AdventureWorks
[X]
»
Database Objects AdventureWorks
Edit
wikibot
adventureworks (mie60)
Edit
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)
Edit
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)
Edit
Procedures
uspGetBillOfMaterials (dbo)
uspGetEmployeeManagers (dbo)
uspGetManagerEmployees (dbo)
uspGetWhereUsedProductID (dbo)
uspLogError (dbo)
uspPrintError (dbo)
uspUpdateEmployeeHireInfo (HumanResources)
uspUpdateEmployeeLogin (HumanResources)
uspUpdateEmployeePersonalInfo (HumanResources)
Edit
Functions
ufnGetAccountingEndDate (dbo)
ufnGetAccountingStartDate (dbo)
ufnGetDocumentStatusText (dbo)
ufnGetProductDealerPrice (dbo)
ufnGetProductListPrice (dbo)
ufnGetProductStandardCost (dbo)
ufnGetPurchaseOrderStatusText (dbo)
ufnGetSalesOrderStatusText (dbo)
ufnGetStock (dbo)
ufnLeadingZeros (dbo)
ufnGetContactInformation (dbo)
Edit
Schemas
HumanResources
Person
Production
Purchasing
Sales
Edit
Types
AccountNumber (dbo)
Flag (dbo)
Name (dbo)
NameStyle (dbo)
OrderNumber (dbo)
Phone (dbo)
Edit
XML Schema Collections
AdditionalContactInfoSchemaCollection (Person)
HRResumeSchemaCollection (HumanResources)
IndividualSurveySchemaCollection (Sales)
ManuInstructionsSchemaCollection (Production)
ProductDescriptionSchemaCollection (Production)
StoreSurveySchemaCollection (Sales)
Edit
Database Triggers
ddlDatabaseTriggerLog
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.