view icon View: vStateProvinceCountryRegion

Properties

Property Value
Name vStateProvinceCountryRegion
ID 2011154210
Schema Person
Owner dbo
Encrypted false
Schema Bound true
With Check Option false
ANSI NULLS true
Uses Quoted Identifier true
Has Opaque Metadata false
Published false
Schema Published false
Replicated false
Has Replication Filter false
Has Unchecked Assembly Data false
Date Correlation View false
Uses Database Collation true
Tracked by CDC false
MS Shipped false
Modify Date 8/8/2010 5:23:46 PM
Create Date 8/8/2010 5:23:46 PM

Extended Properties

Name Value
MS_Description Joins StateProvince table with CountryRegion table.

View Columns

Column Name Datatype Nullable Is Identity
StateProvinceID int false false
StateProvinceCode nchar(3) false false
IsOnlyStateProvinceFlag Flag false false
StateProvinceName Name false false
TerritoryID int false false
CountryRegionCode nvarchar(3) false false
CountryRegionName Name false false

Indexes

Name Index Type Primary Key Unique Unique Constraint Ignore Duplicate Key Disabled
IX_vStateProvinceCountryRegion CLUSTERED false true false false false

Object Level Permissions

No object level permissions defined.

Column Level Permissions

No explicit column permissions granted to this object

Statistics

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
IX_vStateProvinceCountryRegion Aug 8 2010 5:23PM 181 181 91 1 8 false 181

Detailed Statistics Density

All Density Average Length Columns
0.005524862 4 StateProvinceID
0.005524862 8 StateProvinceID, CountryRegionCode

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
1 0 1 0 1
3 1 1 1 1
5 1 1 1 1
7 1 1 1 1
9 1 1 1 1
11 1 1 1 1
13 1 1 1 1
15 1 1 1 1
17 1 1 1 1
19 1 1 1 1
21 1 1 1 1
23 1 1 1 1
25 1 1 1 1
27 1 1 1 1
29 1 1 1 1
31 1 1 1 1
33 1 1 1 1
35 1 1 1 1
37 1 1 1 1
39 1 1 1 1
41 1 1 1 1
43 1 1 1 1
45 1 1 1 1
47 1 1 1 1
49 1 1 1 1
51 1 1 1 1
53 1 1 1 1
55 1 1 1 1
57 1 1 1 1
59 1 1 1 1
61 1 1 1 1
63 1 1 1 1
65 1 1 1 1
67 1 1 1 1
69 1 1 1 1
71 1 1 1 1
73 1 1 1 1
75 1 1 1 1
77 1 1 1 1
79 1 1 1 1
81 1 1 1 1
83 1 1 1 1
85 1 1 1 1
87 1 1 1 1
89 1 1 1 1
91 1 1 1 1
93 1 1 1 1
95 1 1 1 1
97 1 1 1 1
99 1 1 1 1
101 1 1 1 1
103 1 1 1 1
105 1 1 1 1
107 1 1 1 1
109 1 1 1 1
111 1 1 1 1
113 1 1 1 1
115 1 1 1 1
117 1 1 1 1
119 1 1 1 1
121 1 1 1 1
123 1 1 1 1
125 1 1 1 1
127 1 1 1 1
129 1 1 1 1
131 1 1 1 1
133 1 1 1 1
135 1 1 1 1
137 1 1 1 1
139 1 1 1 1
141 1 1 1 1
143 1 1 1 1
145 1 1 1 1
147 1 1 1 1
149 1 1 1 1
151 1 1 1 1
153 1 1 1 1
155 1 1 1 1
157 1 1 1 1
159 1 1 1 1
161 1 1 1 1
163 1 1 1 1
165 1 1 1 1
167 1 1 1 1
169 1 1 1 1
171 1 1 1 1
173 1 1 1 1
175 1 1 1 1
177 1 1 1 1
179 1 1 1 1
181 1 1 1 1

Objects that depend on [vStateProvinceCountryRegion]

Objects on which [vStateProvinceCountryRegion] depends

SQL

Script
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
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];
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Clustered index on the view vStateProvinceCountryRegion.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'VIEW',@level1name=N'vStateProvinceCountryRegion', @level2type=N'INDEX',@level2name=N'IX_vStateProvinceCountryRegion'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Joins StateProvince table with CountryRegion table.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'VIEW',@level1name=N'vStateProvinceCountryRegion'

See also

List of Views