Database AdventureWorksDW
Tables
AdventureWorksDWBuildVersion
DatabaseLog
DimAccount
DimCurrency
DimCustomer
DimDepartmentGroup
DimEmployee
DimGeography
DimOrganization
DimProduct
DimProductCategory
DimProductSubcategory
DimPromotion
DimReseller
DimSalesReason
DimSalesTerritory
DimScenario
DimTime
FactCurrencyRate
FactFinance
FactInternetSales
FactInternetSalesReason
FactResellerSales
FactSalesQuota
ProspectiveBuyer
Views
vAssocSeqLineItems
vAssocSeqOrders
vDMPrep
vTargetMail
vTimeSeries
Stored Procedures
No stored procedures were found.Functions
udfMinimumDate
Triggers
No triggers were found.Indexes
AK_DimAccount_AccountCodeAlternateKey
PK_DimAccount
AK_DimCurrency_CurrencyAlternateKey
PK_DimCurrency_CurrencyKey
IX_DimCustomer_CustomerAlternateKey
IX_DimCustomer_GeographyKey
PK_DimCustomer_CustomerKey
PK_DimDepartmentGroup
IX_DimEmployee_ParentEmployeeKey
IX_DimEmployee_SalesTerritoryKey
PK_DimEmployee_EmployeeKey
PK_DimGeography_GeographyKey
PK_DimOrganization
AK_DimProduct_ProductAlternateKey_StartDate
IX_DimProduct_ProductSubcategoryKey
PK_DimProduct_ProductKey
AK_DimProductCategory_ProductCategoryAlternateKey
PK_DimProductCategory_ProductCategoryKey
AK_DimProductSubcategory_ProductSubcategoryAlternateKey
PK_DimProductSubcategory_ProductSubcategoryKey
AK_DimPromotion_PromotionAlternateKey
PK_DimPromotion_PromotionKey
AK_DimReseller_ResellerAlternateKey
IX_DimReseller_GeographyKey
PK_DimReseller_ResellerKey
PK_DimSalesReason_SalesReasonKey
AK_DimSalesTerritory_SalesTerritoryAlternateKey
PK_DimSalesTerritory_SalesTerritoryKey
PK_DimScenario
AK_DimTime_FullDateAlternateKey
PK_DimTime_TimeKey
AK_FactInternetSales_SalesOrderNumber_SalesOrderLineNumber
IX_FactIneternetSales_ShipDateKey
IX_FactInternetSales_CurrencyKey
IX_FactInternetSales_CustomerKey
IX_FactInternetSales_DueDateKey
IX_FactInternetSales_OrderDateKey
IX_FactInternetSales_ProductKey
IX_FactInternetSales_PromotionKey
AK_FactInternetSalesReason_SalesOrderNumber_SalesOrderLineNumber_SalesReasonKey
AK_FactResellerSales_SalesOrderNumber_SalesOrderLineNumber
IX_FactResellerSales_CurrencyKey
IX_FactResellerSales_DueDateKey
IX_FactResellerSales_EmployeeKey
IX_FactResellerSales_OrderDateKey
IX_FactResellerSales_ProductKey
IX_FactResellerSales_PromotionKey
IX_FactResellerSales_ResellerKey
IX_FactResellerSales_ShipDateKey
IX_FactSalesQuota_EmployeeKey
IX_FactSalesQuota_TimeKey
IX_ProspectiveBuyer_ProspectAlternateKey
Full-Text Catalogs
No full-text catalogs were found.