AdventureWorks 2008-05 OLTP

== automatically generated ==
ms new parser (20091126 231028 AdvWorks2008-05-oltp.instawdb.sql)

=== 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}
ScrewTurn Wiki

Navigation

AdventureWorks 2008-05 OLTP
