Person.vStateProvinceCountryRegion View

Information

NamevStateProvinceCountryRegion
SchemaPerson
Created29.3.2010. 21:58:56
Modified29.3.2010. 21:58:56

SQL Script

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];