Person.vStateProvinceCountryRegion View

Description

Joins StateProvince table with CountryRegion table.

Properties

Creation Date	17/07/2014 16:11
Is Schema Bound
Encrypted
Ansi Nulls

Columns

Column Name	Datatype	Length
StateProvinceID	Integer	4
StateProvinceCode	WChar	3
IsOnlyStateProvinceFlag	dbo.Flag	1
StateProvinceName	dbo.Name	50
TerritoryID	Integer	4
CountryRegionCode	VarWChar	3
CountryRegionName	dbo.Name	50

Objects that Person.vStateProvinceCountryRegion depends on

Database Object	Object Type	Description	Dep Level
Person.CountryRegion	Table	Lookup table containing the ISO standard codes for countries and regions.	1
dbo.Flag	User Defined Data Type		2
dbo.Name	User Defined Data Type		2
Sales.SalesTerritory	Table	Sales territory lookup table.	2
Person.StateProvince	Table	State and province lookup table.	1

View Definition

CREATE VIEW [Person].[vStateProvinceCountryRegion] 
WITH SCHEMABINDING 
AS 

SELECT 
    sp.[StateProvinceID] 
    ,sp.[StateProvinceCode] 
    ,sp.[IsOnlyStateProvinceFlag] 
    ,sp.[Name] AS [StateProvinceName] 
    ,sp.[TerritoryID] 
    ,cr.[CountryRegionCode] 
    ,cr.[Name] AS [CountryRegionName]
FROM [Person].[StateProvince] sp 
    INNER JOIN [Person].[CountryRegion] cr 
    ON sp.[CountryRegionCode] = cr.[CountryRegionCode];

Related Objects

Person Schema
AdventureWorks Database