Property |
Value |
Database schema name |
dbo |
Database table name |
DimGeography |
Friendly name |
Geography |
Table name |
dbo_DimGeography |
Table type |
Table |
Is loaded |
|
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)
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)
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)