Generated using SQL Data Dictionary demo version.


View Person.vStateProvinceCountryRegion


Joins StateProvince table with CountryRegion table.


Column Data Type Nullable
StateProvinceID int
StateProvinceCode nchar(3)
IsOnlyStateProvinceFlag Flag(bit)
StateProvinceName Name(nvarchar(50))
TerritoryID int
CountryRegionCode nvarchar(3)
CountryRegionName Name(nvarchar(50))

Uses: