Difference between revisions of "Database Objects AdventureWorks 2008-05"
(New page: == automatically generated == ms new parser (20091126 221728 AdvWorks2008-05-oltp.instawdb.sql) === Tables === Address (Person) [[Person.AddressType_(table)|...) |
|||
| Line 1: | Line 1: | ||
== automatically generated == | == automatically generated == | ||
| − | ms new parser (20091126 | + | ms new parser (20091126 231028 AdvWorks2008-05-oltp.instawdb.sql) |
=== Tables === | === Tables === | ||
| Line 238: | Line 238: | ||
=== Types === | === Types === | ||
| − | [[.AccountNumber_(type)|AccountNumber ()]] | + | [[dbo.AccountNumber_(type)|AccountNumber (dbo)]] |
| − | [[.Flag_(type)|Flag ()]] | + | [[dbo.Flag_(type)|Flag (dbo)]] |
| − | [[.Name_(type)|Name ()]] | + | [[dbo.Name_(type)|Name (dbo)]] |
| − | [[.NameStyle_(type)|NameStyle ()]] | + | [[dbo.NameStyle_(type)|NameStyle (dbo)]] |
| − | [[.OrderNumber_(type)|OrderNumber ()]] | + | [[dbo.OrderNumber_(type)|OrderNumber (dbo)]] |
| − | [[.Phone_(type)|Phone ()]] | + | [[dbo.Phone_(type)|Phone (dbo)]] |
=== XML Schema Collections === | === XML Schema Collections === | ||
Latest revision as of 23:16, 26 November 2009
Contents
automatically generated[edit]
ms new parser (20091126 231028 AdvWorks2008-05-oltp.instawdb.sql)
Tables[edit]
EmployeeAddress (HumanResources)
EmployeeDepartmentHistory (HumanResources)
EmployeePayHistory (HumanResources)
ProductCostHistory (Production)
ProductDescription (Production)
ProductListPriceHistory (Production)
ProductModelIllustration (Production)
ProductModelProductDescriptionCulture (Production)
ProductProductPhoto (Production)
ProductSubcategory (Production)
PurchaseOrderDetail (Purchasing)
PurchaseOrderHeader (Purchasing)
SalesOrderHeaderSalesReason (Sales)
SalesPersonQuotaHistory (Sales)
TransactionHistory (Production)
TransactionHistoryArchive (Production)
Views[edit]
vAdditionalContactInfo (Person)
vEmployeeDepartment (HumanResources)
vEmployeeDepartmentHistory (HumanResources)
vIndividualDemographics (Sales)
vJobCandidate (HumanResources)
vJobCandidateEducation (HumanResources)
vJobCandidateEmployment (HumanResources)
vProductAndDescription (Production)
vProductModelCatalogDescription (Production)
vProductModelInstructions (Production)
vSalesPersonSalesByFiscalYears (Sales)
vStateProvinceCountryRegion (Person)
vStoreWithDemographics (Sales)
Procedures[edit]
uspGetWhereUsedProductID (dbo)
uspUpdateEmployeeHireInfo (HumanResources)
uspUpdateEmployeeLogin (HumanResources)
uspUpdateEmployeePersonalInfo (HumanResources)
Functions[edit]
ufnGetAccountingStartDate (dbo)
ufnGetDocumentStatusText (dbo)
ufnGetProductDealerPrice (dbo)
ufnGetProductStandardCost (dbo)
ufnGetPurchaseOrderStatusText (dbo)
ufnGetSalesOrderStatusText (dbo)
ufnGetContactInformation (dbo)
Schemas[edit]
Types[edit]
XML Schema Collections[edit]
AdditionalContactInfoSchemaCollection (Person)
HRResumeSchemaCollection (HumanResources)
IndividualSurveySchemaCollection (Sales)
ManuInstructionsSchemaCollection (Production)
