<?xml version="1.0" encoding="utf-8"?>
<html>
  <head>
    <meta http-equiv="X-UA-Compatible" content="IE=8" />
    <link rel="stylesheet" href="../../../css/main.css" type="text/css" />
    <link rel="stylesheet" href="../../../css/jquery.treeview.css" />
    <script src="../../../script/jquery.js" type="text/javascript"></script>
    <script src="../../../script/jquery.cookie.js" type="text/javascript"></script>
    <script src="../../../script/jquery.treeview.js" type="text/javascript"></script>
    <script type="text/javascript">
		                $(document).ready(function(){

		                // first example
		                $("#navigation1").treeview({
			                persist: "location",
			                collapsed: true,
			                unique: true
		                });

		                $("#navigation2").treeview({
			                persist: "location",
			                collapsed: true,
			                unique: true
		                });

		                });
	                </script>
    <title>View</title>
  </head>
  <body>
    <h1>
      <img src="../../../Images/icons/view.png" alt="view icon" /> View: vStateProvinceCountryRegion</h1>
    <h2>Properties</h2>
    <table id="GetViewList">
      <tr>
        <th>Property</th>
        <th>Value</th>
      </tr>
      <tr>
        <td>Name</td>
        <td>vStateProvinceCountryRegion</td>
      </tr>
      <tr>
        <td>ID</td>
        <td>2011154210</td>
      </tr>
      <tr>
        <td>Schema</td>
        <td>
          <a href="../../Schemas/Details/Detail_6.html">Person</a>
        </td>
      </tr>
      <tr>
        <td>Owner</td>
        <td>
          <a href="../../Users/Details/Detail_1.html">dbo</a>
        </td>
      </tr>
      <tr>
        <td>Encrypted</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Schema Bound</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>With Check Option</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>ANSI NULLS</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Uses Quoted Identifier</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Has Opaque Metadata</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Published</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Schema Published</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Replicated</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Has Replication Filter</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Has Unchecked Assembly Data</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Date Correlation View</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Uses Database Collation</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Tracked by CDC</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>MS Shipped</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Modify Date</td>
        <td>8/8/2010 5:23:46 PM</td>
      </tr>
      <tr>
        <td>Create Date</td>
        <td>8/8/2010 5:23:46 PM</td>
      </tr>
    </table>
    <h2>Extended Properties</h2>
    <table>
      <tr>
        <th>Name</th>
        <th>Value</th>
      </tr>
      <tr>
        <td>MS_Description</td>
        <td>Joins StateProvince table with CountryRegion table.</td>
      </tr>
    </table>
    <h2>View Columns</h2>
    <table>
      <tr>
        <th>Column Name</th>
        <th>Datatype</th>
        <th>Nullable</th>
        <th>Is Identity</th>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_2011154210_1.html">StateProvinceID</a>
        </td>
        <td>int</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_2011154210_2.html">StateProvinceCode</a>
        </td>
        <td>nchar(3)</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_2011154210_3.html">IsOnlyStateProvinceFlag</a>
        </td>
        <td>Flag</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_2011154210_4.html">StateProvinceName</a>
        </td>
        <td>Name</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_2011154210_5.html">TerritoryID</a>
        </td>
        <td>int</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_2011154210_6.html">CountryRegionCode</a>
        </td>
        <td>nvarchar(3)</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_2011154210_7.html">CountryRegionName</a>
        </td>
        <td>Name</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
    </table>
    <h2>Indexes</h2>
    <table>
      <tr>
        <th>Name</th>
        <th>Index Type</th>
        <th>Primary Key</th>
        <th>Unique</th>
        <th>Unique Constraint</th>
        <th>Ignore Duplicate Key</th>
        <th>Disabled</th>
      </tr>
      <tr>
        <td>
          <a href="Indexes/Detail_2011154210_1.html">IX_vStateProvinceCountryRegion</a>
        </td>
        <td>CLUSTERED</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
    </table>
    <h2>Object Level Permissions</h2>
    <span>No object level permissions defined.</span>
    <h2>Column Level Permissions</h2>
    <span>No explicit column permissions granted to this object</span>
    <h2>Statistics</h2>
    <h3>Detailed Statistics General</h3>
    <table>
      <tr>
        <th>Name<th>Updated</th><th>Rows</th><th>Rows Sampled</th><th>Steps</th><th>Density</th><th>Average Key Length</th><th>String Index</th><th>Filter Expression</th><th>Unfiltered Rows</th></th>
      </tr>
      <tr>
        <td>IX_vStateProvinceCountryRegion</td>
        <td>Aug  8 2010  5:23PM</td>
        <td>181</td>
        <td>181</td>
        <td>91</td>
        <td>1</td>
        <td>8</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td></td>
        <td>181</td>
      </tr>
    </table>
    <h3>Detailed Statistics Density</h3>
    <table>
      <tr>
        <th>All Density</th>
        <th>Average Length</th>
        <th>Columns</th>
      </tr>
      <tr>
        <td>0.005524862</td>
        <td>4</td>
        <td>StateProvinceID</td>
      </tr>
      <tr>
        <td>0.005524862</td>
        <td>8</td>
        <td>StateProvinceID, CountryRegionCode</td>
      </tr>
    </table>
    <h3>Detailed Statistics Histogram</h3>
    <table>
      <tr>
        <th>Range High Key</th>
        <th>Range Rows</th>
        <th>Estimated Rows</th>
        <th>Distinct Range Rows</th>
        <th>Avg Range Rows</th>
      </tr>
      <tr>
        <td>1</td>
        <td>0</td>
        <td>1</td>
        <td>0</td>
        <td>1</td>
      </tr>
      <tr>
        <td>3</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>5</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>7</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>9</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>11</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>13</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>15</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>17</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>19</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>21</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>23</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>25</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>27</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>29</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>31</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>33</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>35</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>37</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>39</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>41</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>43</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>45</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>47</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>49</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>51</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>53</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>55</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>57</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>59</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>61</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>63</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>65</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>67</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>69</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>71</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>73</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>75</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>77</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>79</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>81</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>83</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>85</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>87</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>89</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>91</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>93</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>95</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>97</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>99</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>101</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>103</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>105</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>107</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>109</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>111</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>113</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>115</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>117</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>119</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>121</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>123</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>125</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>127</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>129</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>131</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>133</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>135</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>137</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>139</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>141</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>143</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>145</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>147</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>149</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>151</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>153</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>155</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>157</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>159</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>161</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>163</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>165</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>167</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>169</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>171</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>173</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>175</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>177</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>179</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
      <tr>
        <td>181</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
        <td>1</td>
      </tr>
    </table>
    <h2>Objects that depend on [vStateProvinceCountryRegion]</h2>
    <ul id="navigation1">
      <li>
        <a href="../../Views/Details/Detail_2011154210.html">Person.vStateProvinceCountryRegion</a>
      </li>
    </ul>
    <h2>Objects on which [vStateProvinceCountryRegion] depends</h2>
    <ul id="navigation2">
      <li>
        <a href="../../Views/Details/Detail_2011154210.html">Person.vStateProvinceCountryRegion</a>
        <ul>
          <li>
            <a href="../../Tables/Details/Detail_549576996.html">Person.CountryRegion</a>
            <ul>
              <li>
                <a href="../../Datatypes/Details/Detail_260.html">dbo.Name</a>
              </li>
            </ul>
          </li>
          <li>
            <a href="../../Tables/Details/Detail_206623779.html">Person.StateProvince</a>
            <ul>
              <li>
                <a href="../../Datatypes/Details/Detail_258.html">dbo.Flag</a>
              </li>
              <li>
                <a href="../../Tables/Details/Detail_1666104976.html">Sales.SalesTerritory</a>
              </li>
            </ul>
          </li>
        </ul>
      </li>
    </ul>
    <h2>SQL</h2>
    <table>
      <tr>
        <th>Script</th>
      </tr>
      <tr>
        <td>SET ANSI_NULLS ON<br />SET QUOTED_IDENTIFIER ON<br />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];
<br />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'<br />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'<br /></td>
      </tr>
    </table>
    <h4 class="seealso">See also</h4>
    <a href="../General.html">List of Views</a>
  </body>
</html>