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 »
Back
History
Database Objects AdventureWorks
== wikibot == adventureworks (mie60) === 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} === Database Triggers === [ddlDatabaseTriggerLog_(database_trigger)|ddlDatabaseTriggerLog] {br}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.