Database reference - Adventure Works DW

Table - dbo_DimGeography

Table properties

name	value
name	dbo_DimGeography
data source view	Adventure Works DW
case sensitive	False
display expression
friendly name	DimGeography
db schema name	dbo
db table name	DimGeography
type	Table

Columns

name	nulls	caption	data type	ordinal	unique	auto increment	auto increment seed	auto increment step	datetime mode	max length	is logical	db column name	computed column expression
GeographyKey	False	GeographyKey	Int32	0	True	True	0	1				GeographyKey
City	True	City	String	1	False					30		City
StateProvinceCode	True	StateProvinceCode	String	2	False					3		StateProvinceCode
StateProvinceName	True	StateProvinceName	String	3	False					50		StateProvinceName
CountryRegionCode	True	CountryRegionCode	String	4	False					3		CountryRegionCode
PostalCode	True	PostalCode	String	5	False					15		PostalCode
EnglishCountryRegionName	True	EnglishCountryRegionName	String	6	False					50		EnglishCountryRegionName
SpanishCountryRegionName	True	SpanishCountryRegionName	String	7	False					50		SpanishCountryRegionName
FrenchCountryRegionName	True	FrenchCountryRegionName	String	8	False					50		FrenchCountryRegionName
SalesTerritoryKey	True	SalesTerritoryKey	Int32	9	False							SalesTerritoryKey

References

parent column	child column	relation name	nested
dbo_DimSalesTerritory.	dbo_DimGeography.	FK_DimGeography_DimSalesTerritory	False

Referenced by

parent column	child column	relation name	nested
dbo_DimSalesTerritory.	dbo_DimGeography.	FK_DimGeography_DimSalesTerritory	False

Foreign key graph

dbo_DimSalesTerritorydbo_DimGeography dbo_DimCustomerdbo_DimReseller

Dependency graph

Adventure Works DWdbo_DimGeography

Objects that dbo_DimGeography depends on

name	object type	level
Adventure Works DW	DataSourceView	1

Documentation generated by SqlSpec