Object type: Data view

Joins StateProvince table with CountryRegion table.

Properties 

Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
No	No	No	No	No

Data Source Activity 

Accesses	Description
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.StateProvince	State and province lookup table.

Output Recordset 

Column	Description
StateProvinceID
StateProvinceCode
IsOnlyStateProvinceFlag
StateProvinceName
TerritoryID
CountryRegionCode
CountryRegionName

Data source	Description
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.StateProvince	State and province lookup table.

Indices 

Name	Description
IX_vStateProvinceCountryRegion	Clustered index on the view vStateProvinceCountryRegion.

Applies to

Views

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation