Table: DimGeography

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   DimGeography 
 Friendly name   Geography 
 Table name   dbo_DimGeography 
 Table type   Table 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


Relation name  Child (foreign key) columns  Parent name  Parent type  Parent (primary key) columns 
FK_DimGeography_DimSalesTerritory SalesTerritoryKey DimSalesTerritory Table SalesTerritoryKey
Total: 1 parent relationship(s)

Collapse image Child relations


Relation name  Parent (primary key) columns  Child name  Child type  Child (foreign key) columns 
FK_DimReseller_DimGeography GeographyKey DimReseller Table GeographyKey
FK_DimCustomer_DimGeography GeographyKey DimCustomer Table GeographyKey
Total: 2 child relationship(s)

Collapse image Columns


Name  Type  Computed column expression 
GeographyKey System.Int32  
City System.String  
StateProvinceCode System.String  
StateProvinceName System.String  
CountryRegionCode System.String  
PostalCode System.String  
EnglishCountryRegionName System.String  
SpanishCountryRegionName System.String  
FrenchCountryRegionName System.String  
SalesTerritoryKey System.Int32  
IpAddressLocator System.String  
Total: 11 column(s)

Collapse image See also


About this documentation