Views [Person].[vStateProvinceCountryRegion]
Joins StateProvince table with CountryRegion table.
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
ANSI Nulls OnTrue
Quoted Identifier OnTrue
Schema BoundTrue
Created13:14:55 14 marca 2012
Last Modified13:14:55 14 marca 2012
KeyNameData TypeMax Length (Bytes)
Cluster Key IX_vStateProvinceCountryRegion: StateProvinceID\CountryRegionCodeStateProvinceIDint4
StateProvinceCodenchar(3)6
IsOnlyStateProvinceFlag[dbo].[Flag]1
StateProvinceName[dbo].[Name]100
TerritoryIDint4
Cluster Key IX_vStateProvinceCountryRegion: StateProvinceID\CountryRegionCodeCountryRegionCodenvarchar(3)6
CountryRegionName[dbo].[Name]100
KeyNameKey ColumnsUniqueDescription
Cluster Key IX_vStateProvinceCountryRegion: StateProvinceID\CountryRegionCodeIX_vStateProvinceCountryRegionStateProvinceID, CountryRegionCode
True
Clustered index on the view vStateProvinceCountryRegion.

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];
GO
CREATE UNIQUE CLUSTERED INDEX [IX_vStateProvinceCountryRegion] ON [Person].[vStateProvinceCountryRegion] ([StateProvinceID], [CountryRegionCode]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Joins StateProvince table with CountryRegion table.', 'SCHEMA', N'Person', 'VIEW', N'vStateProvinceCountryRegion', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_Description', N'Clustered index on the view vStateProvinceCountryRegion.', 'SCHEMA', N'Person', 'VIEW', N'vStateProvinceCountryRegion', 'INDEX', N'IX_vStateProvinceCountryRegion'
GO