Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

ViewPerson.vStateProvinceCountryRegion
DescriptionJoins StateProvince table with CountryRegion table.

Source

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

References

Dependency TypeObject TypeReferenced Object
SelectTablePerson.CountryRegion
SelectTablePerson.StateProvince
SchemaSchemaPerson

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.