Person.vStateProvinceCountryRegion View

Description

Joins StateProvince table with CountryRegion table.

Properties

Creation Date	08/01/2010 08:41
Is Schema Bound
Encrypted
Ansi Nulls

Columns

Column Name	Datatype	Length
StateProvinceID	int	4
StateProvinceCode	nchar	3
IsOnlyStateProvinceFlag	dbo.Flag	1
StateProvinceName	dbo.Name	50
TerritoryID	int	4
CountryRegionCode	nvarchar	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