ProjectVersion Script - XML - MediaWiki ProjectVersion overview

From dbscript Online Help
Revision as of 17:24, 8 December 2008 by Ho (talk | contribs) (Description)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Description[edit]

This page has been generated using dbscript

Select Project, Project Version, Command "Generate Script"

Select "XML", and predefined XSLT "MediaWiki ProjectVersion overview"

Screenshot

Generated Code:

adventureworks (mie54)[edit]

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)