Difference between revisions of "Database Objects AdventureWorks"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == === Tables === Address (Person) AddressType (Person) AWBuildVersion (dbo) [[P...)
 
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
== wikibot ==
 
== wikibot ==
 +
adventureworks (mie60)
  
 
=== Tables ===
 
=== Tables ===
Line 222: Line 223:
 
 
 
[[dbo.ufnGetContactInformation_(function)|ufnGetContactInformation (dbo)]]
 
[[dbo.ufnGetContactInformation_(function)|ufnGetContactInformation (dbo)]]
 +
 +
=== Schemas ===
 +
 +
[[HumanResources_(schema)|HumanResources]]
 +
 +
[[Person_(schema)|Person]]
 +
 +
[[Production_(schema)|Production]]
 +
 +
[[Purchasing_(schema)|Purchasing]]
 +
 +
[[Sales_(schema)|Sales]]
 +
 +
=== Types ===
 +
 +
[[dbo.AccountNumber_(type)|AccountNumber (dbo)]]
 +
 +
[[dbo.Flag_(type)|Flag (dbo)]]
 +
 +
[[dbo.Name_(type)|Name (dbo)]]
 +
 +
[[dbo.NameStyle_(type)|NameStyle (dbo)]]
 +
 +
[[dbo.OrderNumber_(type)|OrderNumber (dbo)]]
 +
 +
[[dbo.Phone_(type)|Phone (dbo)]]
 +
 +
=== XML Schema Collections ===
 +
 +
[[Person.AdditionalContactInfoSchemaCollection_(xml_schema_collection)|AdditionalContactInfoSchemaCollection (Person)]]
 +
 +
[[HumanResources.HRResumeSchemaCollection_(xml_schema_collection)|HRResumeSchemaCollection (HumanResources)]]
 +
 +
[[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|IndividualSurveySchemaCollection (Sales)]]
 +
 +
[[Production.ManuInstructionsSchemaCollection_(xml_schema_collection)|ManuInstructionsSchemaCollection (Production)]]
 +
 +
[[Production.ProductDescriptionSchemaCollection_(xml_schema_collection)|ProductDescriptionSchemaCollection (Production)]]
 +
 +
[[Sales.StoreSurveySchemaCollection_(xml_schema_collection)|StoreSurveySchemaCollection (Sales)]]
 +
 +
=== Database Triggers ===
 +
 +
[[ddlDatabaseTriggerLog_(database_trigger)|ddlDatabaseTriggerLog]]

Latest revision as of 00:05, 3 February 2010

wikibot[edit]

adventureworks (mie60)

Tables[edit]

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[edit]

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[edit]

uspGetBillOfMaterials (dbo)

uspGetEmployeeManagers (dbo)

uspGetManagerEmployees (dbo)

uspGetWhereUsedProductID (dbo)

uspLogError (dbo)

uspPrintError (dbo)

uspUpdateEmployeeHireInfo (HumanResources)

uspUpdateEmployeeLogin (HumanResources)

uspUpdateEmployeePersonalInfo (HumanResources)

Functions[edit]

ufnGetAccountingEndDate (dbo)

ufnGetAccountingStartDate (dbo)

ufnGetDocumentStatusText (dbo)

ufnGetProductDealerPrice (dbo)

ufnGetProductListPrice (dbo)

ufnGetProductStandardCost (dbo)

ufnGetPurchaseOrderStatusText (dbo)

ufnGetSalesOrderStatusText (dbo)

ufnGetStock (dbo)

ufnLeadingZeros (dbo)

ufnGetContactInformation (dbo)

Schemas[edit]

HumanResources

Person

Production

Purchasing

Sales

Types[edit]

AccountNumber (dbo)

Flag (dbo)

Name (dbo)

NameStyle (dbo)

OrderNumber (dbo)

Phone (dbo)

XML Schema Collections[edit]

AdditionalContactInfoSchemaCollection (Person)

HRResumeSchemaCollection (HumanResources)

IndividualSurveySchemaCollection (Sales)

ManuInstructionsSchemaCollection (Production)

ProductDescriptionSchemaCollection (Production)

StoreSurveySchemaCollection (Sales)

Database Triggers[edit]

ddlDatabaseTriggerLog