Database reference - Adventure Works DW

Table - dbo_DimSalesTerritory

Table properties

namevalue
namedbo_DimSalesTerritory 
data source viewAdventure Works DW 
case sensitiveFalse 
display expression 
friendly nameDimSalesTerritory 
db schema namedbo 
db table nameDimSalesTerritory  
typeTable  

Columns

namenullscaptiondata typeordinaluniqueauto incrementauto increment seedauto increment stepdatetime modemax lengthis logicaldb column namecomputed column expression
SalesTerritoryKey  False  SalesTerritoryKey  Int32  0  True  True  0  1        SalesTerritoryKey   
SalesTerritoryAlternateKey  True  SalesTerritoryAlternateKey  Int32  1  False              SalesTerritoryAlternateKey   
SalesTerritoryRegion  False  SalesTerritoryRegion  String  2  False          50    SalesTerritoryRegion   
SalesTerritoryCountry  False  SalesTerritoryCountry  String  3  False          50    SalesTerritoryCountry   
SalesTerritoryGroup  True  SalesTerritoryGroup  String  4  False          50    SalesTerritoryGroup   

Referenced by

parent columnchild columnrelation namenested

Foreign key graph

dbo_DimSalesTerritorydbo_DimEmployeedbo_DimGeographydbo_FactInternetSalesdbo_FactResellerSalesFactSalesSummary

Dependency graph

Adventure Works DWdbo_DimSalesTerritory

Objects that dbo_DimSalesTerritory depends on

nameobject typelevel
Adventure Works DWDataSourceView1



Documentation generated by SqlSpec