Person.vStateProvinceCountryRegion

[Person].[vStateProvinceCountryRegion]

Joins StateProvince table with CountryRegion table.

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
ANSI Nulls On	True
Quoted Identifier On	True
Schema Bound	True
Created	13:14:55 14 marca 2012
Last Modified	13:14:55 14 marca 2012

Columns

Key	Name	Data Type	Max Length (Bytes)
$Cluster Key IX_vStateProvinceCountryRegion: StateProvinceID\CountryRegionCode$	StateProvinceID	int	4
	StateProvinceCode	nchar(3)	6
	IsOnlyStateProvinceFlag	[dbo].[Flag]	1
	StateProvinceName	[dbo].[Name]	100
	TerritoryID	int	4
$Cluster Key IX_vStateProvinceCountryRegion: StateProvinceID\CountryRegionCode$	CountryRegionCode	nvarchar(3)	6
	CountryRegionName	[dbo].[Name]	100

Indexes

Key	Name	Key Columns	Unique	Description
$Cluster Key IX_vStateProvinceCountryRegion: StateProvinceID\CountryRegionCode$	IX_vStateProvinceCountryRegion	StateProvinceID, CountryRegionCode	True	Clustered index on the view vStateProvinceCountryRegion.

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

Uses